Can you give us more specific examples, as show the value that would be in
column A, units, and the way you'd arrive at the result manually, along with
the resulting cost you would expect?

It looks to me like the price is going up for quantity purchases, and that's
not the usual business model? And what's the price for units if purchased
quantity is LESS THAN 100?

"janet" wrote:

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!