I have this pricing structure:
items 0-10 price is 10 . So the first 10 items are 100.
items 11-50 price is 8 .So is 100 for the first and 40x8=320 ,total 420
items 51-100 price is 6.So 100+320=420 and 50x6=300.If someone buys 100 will pay 720.
After the 100 items the price is 5 and here is the end.
I need a formula that I will put a number in a cell ,like 55.That means that it will show the number 450.because.:10x10=100 +40x8=320 +5x6=30.
We add and 100+320+30=450.
There is a problem with this one:
=IF(A1<11,A1*10)+IF(AND(A1>10,A1<52),100+(A1-10)*8)+IF(AND(A1>51,A1<101),100+320+(A1*6))+IF(A1> 100,720+(A1*5))
When I put the number 55 I get 750.