If Formula to calculate a score

KG14

New member
Joined
Jan 16, 2013
Messages
3
Reaction score
0
Points
0
Hello :)

Please could I get some assistance on a formula to calculate the below scores. The if formulas that I have been trying to use are not working.

If i have these % weightings how do i use an if formula to get the below scores?

Target Score
<90% 0
>=90% 1
>=95% 2
>=100% 3
>=110% 4
>=120% 5
 
Thank you so much. this works wonderfully!!!
 
You could also use a combination of ifs if you would like to. Thought the above solution seems better.
 
Back
Top