View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default "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