Glad you got a solution that worked. I just wanted to perhaps head off
confusion early, but you had accurately described your situation and so
things worked out well.

"janet" wrote:

On 1 Oct, 13:15, Pete_UK wrote:
It's strange to have unit prices going up with increasing orders - why
not just order 3 lots of 100 rather than 300 in one go? Also, the
numbers you have chosen to illustrate your example will make the
formula a bit confusing, but try this in B1:

=IF(A1<=100,A1*100,IF(A1<=200,100*100+(A1-100)*200,100*100+100*200+
(A1-200)*300))

Hope this helps.

Pete

On Oct 1, 12:40 pm, 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!- Hide quoted text -

- Show quoted text -

Thanks, this has worked.
For info we just have a slightly complicated contract whereby the
price per unit changes because of different overheads depending how
many units there are