Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If this, multiply by this" type of equation
Thank you!!
"Pete_UK" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If this, multiply by this" type of equation
You're welcome.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
how do you type squares or "to the power" in excel?? | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |