Score based on percentage value from range percentage

[mrwiley]

Good day,

I know I can make this simpler but I am sending this out to the world of the company and need to keep it "concise".

I need to have a value "score" selected based on % given however, the options to pick the value "score" needs to be obtained using the range below

A B

On Time	Score
100%	40
95-99%	35
90-94%	30
85-89%	25
80-84%	20
75-79%	15
70-74%	10
65-69%	5
<64%	0

<tbody>
</tbody>

I have tried IF(and( and IF(Or etc... nested if... The issue is the % is given based on completions - if the whole % of 76% then it would equal 15.

Any ideas you could share?

Thanks

 

[Fluff]

How about
=LOOKUP(A2,{0,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1},{0,5,10,15,20,25,30,35,40})

 

[mrwiley]

Never even thought about lookup... thanks so much! Amazing.

 

[Fluff]

You're welcome & thanks for the feedback