| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total sum based on different costs for each new quantity group
How do I calculate this situation?
Assumptions: For the first 500 units, the cost per unit is $25 Between 501-1000 units, the cost per unit is $17.50 Between 1001-2000 units, the cost per unit is $10 To calculate total cost for 1,900 units, I have to say: (500*$25) + (499*$17.50) + (901*$10) -- t |
| 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 | |||
Threaded Mode
