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

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