View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tboogie21 Tboogie21 is offline
external usenet poster
 
Posts: 2
Default 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