"If this, multiply by this" type of equation
In need to enter an amount in H9 that is equal to an amount in B5 and then
the amount entered in either B14 or B15 depending. Ex: B5 is either a compact
car or a luxury car. B14 contains the charge/day for compact. B15 contains
the charge/day for luxury. So, if B5 is compact, I need to multiply it by
B14. BUT, if B5 is luxury, then I need to multiply it by B15. How would I set
up this equation for an "if this vehicle, multiply by this amount"?
|