Percentage Weighting

[TheRevenant]

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%



I cannot post attachments on this forum. So here is the setup:

If A4= my value for X, B4=30%, and

C4=MIN(40,B4*(MIN(80,80*A4/70)+MIN(20,4*MAX(0,A4-70))+2*MAX(0,A4-75)))

It's not correct. X=80 should give me 40% (100% of 30% + 10%).

Anything beyond 80%: 81,82,83,100, should give me at most 40%.

Does anyone know what I need to include to very the percentage after 80%?

Thanks a bunch

 

[dUBBINS]

Honestly, I am a little confused. However, I noticed one thing that might be something to look at.

You have "80" in your formula. If this is 80%, shouldn't it be "0.8" ?

 

[TheRevenant]

You can divide or multiply by 100% either way where I am stuck is varying after 80%.