Hello,
if possible i need the following to display in a cell if the conditions below are met:
If between 85 and 89 inclusive is displayed i need the adjacent cell to display "R".
If betwen 90 and 94 inclusive then cell should read "A"
and, if between 95 and 100 displayed then adjacent cell should display "G".
Btw, the R,A,G, is just a RED , AMBER, GREEN scoring.
Cheers.
Bookmarks