| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format group of rows based on condition | Excel Discussion (Misc queries) | |||
| calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
| Subtotaling based on more than one group | Excel Worksheet Functions | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Hybrid Mode
