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
[TABLE="width: 159"]
<tbody>[TR]
[TD]On Time[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]100%[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]95-99%[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]90-94%[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]85-89%[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]80-84%[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]75-79%[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]70-74%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]65-69%[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]<64%[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

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