Score based on percentage value from range percentage

mrwiley

Board Regular
Joined
Sep 10, 2012
Messages
56
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 TimeScore
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
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,389
Office Version
365
Platform
Windows
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})
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,389
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,082,479
Messages
5,365,792
Members
400,854
Latest member
zenith_11

Some videos you may like

This Week's Hot Topics

Top