"If this, multiply by this" type of equation
Presumably you have number of days somewhere - assume this is A1. A
formula like this in H9 should give you what you want:
=IF(B5="compact",A1*B14,IF(B5="luxury",A1*B15,"no car"))
If you don't have either "compact" or "luxury" in B5 you will get the
message "no car".
Hope this helps.
Pete
|