hi!

why don't u try

=IF(AND(A5=85,A5<90),"R",IF(AND(A5=90,A5<=94),"A ",IF(AND(A5=95,A5<=100),"G","")))

-via135


fodman Wrote:
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.


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