How do I create the following calculation based on volume

C

ckightly

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help please 2
Locating values in a range and bringing up the corresponding price 3
Finding the corresponding value in a range? 4
How to dynamically add up varying # of cells base on a value 6
How do I add multiple values in an array based on multiple hits? 11
How do I scan a large table/worksheet for values? 1
If time Go to Function 1
multiple ranking (sorting), based on diff. criteria 0

Top