IF formulas with more than two possible values
On second thought, the right formula will be:
=(A10)*(IF(A1<=100,A1,100)*100+(A1100)*IF(A1<=20 0,A1-100,100)*200+(A1200)*(A1-200)*300)
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!
|