Total sum based on different costs for each new quantity group
Thanks!
--
t
"MartinW" wrote:
To calculate total cost for 1,900 units, I have to say:
(500*$25) + (499*$17.50) + (901*$10)
First up this bit isn't right, it should read
(500*$25) + (500*$17.50) + (900*$10)
With the following input
A1 = 25
A2 = 17.50
A3 = 10
B1 = 1900
Then put this in C1
=IF(B11000,((B1-1000)*A3)+(A2*500)+(A1*500),IF(AND(B1<1000,B1500) ,(B1-500)*A2+(A1*500),B1*A1))
HTH
Martin
|