Thread
:
Excel Logical Formula
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Excel Logical Formula
I am also confused about what you are doing but try this idea
=if(and(j5=316226,,j5<3162276),"amber",next if)
Don Guillett
SalesAid Software
"ju1eshart" wrote in message
...
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
Reply With Quote