Hello,

I am bit new to excel and stuck to caluclate a value, below is the situation:

A B C

threshold rate

0 20,000 0

20,001 60,000 2.43

60,001 120,000 2.18

120,001 240,000 1.94

240,001 480,000 1.70

480,001 + 1.46

Total Units Sold: 700,000

Given above are:

Colums A & B (merged) = Threshold

Column C = Rate for 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 which calculate value as per given threshlod for total units.

Any urgent help will be really appreciated.