I have the following formula
=IF(AND(J5<316226),"Green",IF(AND(J5>=3162277),"Red",IF(AND(J5>=316228),"Amber",IF(AND(J5<=3162276),"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
Bookmarks