Thanks Franz. Your suggestion worked the best. Your help is much appreciated.
Jules - Scotland

"Franz Verga" wrote:

Nel post
*ju1eshart* ha scritto:

I have the following formula
=IF(AND(J5<316226),"Green",IF(AND(J5=3162277),"Re d",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


Try this way:

=IF(J5="","",IF(J5<316226,"Green",IF(J5=3162277," Red",IF(J5=316228,"Amber",IF(J5<=3162276,"Amber") ))))

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy