J
janet
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!
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!