| 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"? |
| 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) | |||
Threaded Mode
