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
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