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