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.