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.


--
fodman
------------------------------------------------------------------------
fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941
View this thread: http://www.excelforum.com/showthread...hreadid=555265