I have the following formula in a total price cell for a spreadsheet that generates quotes. The cell has to lookup info if the drop down menu under "what service" cell has something other than respite care. If it has respite care, the price needs to be $150, regardless of the inputs in the other...