=IF(AND(J5<316226),"Green",IF(AND(J5=3162277),"Re
d",IF(AND(J5=316228),"Amber",IF(AND(J5<=316227 6), "Amber"))))
I'd like to include the comment "NO DATA" if the ref cell is not
populated
with a value. I thought " " ment empty cell but I can't get it to
work.
Thanks in advance for your help

You do not need the AND statements in your original expression

IF(J5<316226,"Green",IF(J5=3162277,"Red",IF(J5=3 16228,"Amber",IF(J5<=3162276,
"Amber",if(isblank(j5),"NO DATA"," ")))))

or even
IF(J5<316226,"Green",IF(J5=3162277,"Red",IF(J5=3 16228,"Amber",IF(J5<=3162276,
"Amber","NO DATA"," "))))

If it is just the only situation left
Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=555519