| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create the following calculation based on volume
0-500 $.55
501-600 $.65 601-700 $.70 701-800 $.80 801+ $.90 Each tier is exculsive of each other and must have a complete sum. For example: Total of 752 units would be 0-500 $.55 = $275 501-600 $.65 =$65.00 601-700 $.70 =$70 701-800 $.80 (752=52 units)= $41.60 A total of $451.60 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create the following calculation based on volume
John McGimpsey has a web page on this subject:
http://www.mcgimpsey.com/excel/variablerate.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ckightly" wrote in message ... 0-500 $.55 501-600 $.65 601-700 $.70 701-800 $.80 801+ $.90 Each tier is exculsive of each other and must have a complete sum. For example: Total of 752 units would be 0-500 $.55 = $275 501-600 $.65 =$65.00 601-700 $.70 =$70 701-800 $.80 (752=52 units)= $41.60 A total of $451.60 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALCULATION BASED ON MORE THAN TWO CONDITIONS | Excel Discussion (Misc queries) | |||
| Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
| Sum calculation based on condition | Excel Worksheet Functions | |||
| Calculation based on 2 cols | Excel Discussion (Misc queries) | |||
| Calculation based on a condition | Excel Worksheet Functions | |||
Linear Mode
