Calculate Value as per given threshold

[uarshad83]

Hello,

I am bit new to excel and stuck to calculate a value, please find enclosed sheet with data:


Colums A & B (merged) = Threshold

Column C = Rates for given thresholds

If there are total 700,000 units sold how I can calculate value of it considering given threshold and calculate value of it as per threshold. Means, I want a formula in C9 which calculate value as per given threshold for total units.

Any urgent help will be really appreciated.

 

[John Jairo V]

Hi @uarshad83!

Check this post:
http://forum.chandoo.org/threads/figuring-out-cumulative-commissions.34901/#post-208460

Blessings!

 

[p45cal]

…so in C9:

=SUMPRODUCT(--(B9>B2:B6),(B9-B2:B6),(C3:C7-C2:C6))

Column A is redundant.