Complex Logic Statements
It might not even be possible, but I need to know how to have a cell be populated with a value based on multiple criteria. Scenario - every audit costs a different amount, if it is 2 day or 3 day, remote or onsite, etc. I would like the line item to be able to populate based on column B = number of days and column C=remote or onsite to end in column D with a value. There would have to be a "key" somewhere for the different combinations. Is that even a thing?
two day + onsite returns value of $15,000.00
three day + onsite returns a value of $18,000.00
two day + remote returns a value of $11,500.00
three day + remote returns a value of $14,500.00
Help Article Resources
Check out the Formula Handbook template!