I have a spread sheet. I contains in one of the columns scores. I would like the text in the adjacent cell to automatically update with text, depending on the score in the original column.
Eg If the score in H2 is 100, I’d like the cell I2 to say Full Compliance
If H3 has a score of 84 I’d like I5 to say Substantial Compliance… and so on
The scores are as follows
100 = Full Compliance
80 to 99 = Substantial Compliance
41 to 79 – Limited Compliance
40 or below = Little of No Compliance.
Can someone help me with this?
Many thanks
D
Bookmarks