"If this, multiply by this" type of equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column multiplied by single cell 4
Countif question how do I do this ? 8
sumif help 3
IF AND problem 5
Help with time conversions 4
IF / OR Function 7
If And Calcuation 4
I'am not sure if this is a (=if) problem 4

Back
Top