Hi there,
I need to calculate some weighted percentages with the following criteria:
If X=70% then I multiply 80% of 30%
If X=75% then I multiply 100% of 30%
If X=80% then I add 10% to the 30%
Anything beyond 80% is at most 40%.
How do I calculate what this percentage will be if say for example, X = 73%? It's expected to be over 80%.
1. If X<70%
2. If 70%<=X<75%
3. If 75%<=X<80%
if X = 69% it will be less than 24% (less than 80% of 30%)
if X = 73%, the percentage will be between 24%-30% (between 80% and 100% of 30%), how can I determine how this is scaled?
if X = 81%, then it will be at most 40%
Thanks bunch!
Bookmarks