IF formulas with more than two possible values
Hi
=((A1<=100)+(A1<=200)+(A1200))*100
Arvi Laanemets
"janet" wrote in message
...
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!
|