28creation
Board Regular
- Joined
- Oct 13, 2014
- Messages
- 124
Hi all,
I'm currently designing a scorecard in work which gives a certain weighting for several objectives...
OBJ 1 - 10%
OBJ 2 - 5%
OBJ 3 - 7.5%
etc, etc
Some cells contain words, such as outstanding, achieving, developing, etc & I've been able to give a % weight to each of these with this formula...
=IF(O8="OUTSTANDING","25%",(IF(O8="EXCEEDING","20%",(IF(O8="ACHIEVING","15%",(IF(O8="DEVELOPING","10%",(IF(O8="UNACCEPTABLE","5%",(IF(O8="","")))))))))))
Other objectives have numbers or percentages instead of words but using the same formula doesn't work. Can anyone help edit the formula or give me an alternative please?
Thanks in advance.
I'm currently designing a scorecard in work which gives a certain weighting for several objectives...
OBJ 1 - 10%
OBJ 2 - 5%
OBJ 3 - 7.5%
etc, etc
Some cells contain words, such as outstanding, achieving, developing, etc & I've been able to give a % weight to each of these with this formula...
=IF(O8="OUTSTANDING","25%",(IF(O8="EXCEEDING","20%",(IF(O8="ACHIEVING","15%",(IF(O8="DEVELOPING","10%",(IF(O8="UNACCEPTABLE","5%",(IF(O8="","")))))))))))
Other objectives have numbers or percentages instead of words but using the same formula doesn't work. Can anyone help edit the formula or give me an alternative please?
Thanks in advance.