Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formulas with more than two possible values
How do i create a condition based on another cell with more than two
possibilities? i.e., column A shows the number of units, and in cell B i need to work out the total price, but the unit price changes according to how many units there are eg = 100 units, price = £100; 100<201 units, price = £200 (therefore (100*100) + (x*200)); =201 units, price = £300 (therefore (100*100) + (100*200) + (x*300) Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep Values and Formulas | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
values in IF formulas | Excel Worksheet Functions | |||
Formulas as Values | Excel Discussion (Misc queries) | |||
Formulas with "Y" & "N" values | Excel Discussion (Misc queries) |