Nel post
*fodman* ha scritto:

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.


Hi,

try this:

=IF(ISNA(LOOKUP(C17,{85,90,95},{"R","A","G"})),"", IF(C17100,"",LOOKUP(C17,{85,90,95},{"R","A","G"}) ))

where C17 is the cell to test. If the value in C17 is lower than 85 or
higher than 100, the formula result is "" (a null string), i.e. the cell
will look empty.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy