trapping empty values

iksotof
3StarLounger
Posts: 313
Joined: 04 May 2010, 15:18

trapping empty values

Post by iksotof »

Hi,

I have he followign condition that works almost as required:

=IF(AND(K14="",TODAY()-H14>42),"6 Week Alert",""), where there is no value in H4 though I require it not to show "6 week slert", which it currenlty does. How can I amend accordingly?


Thank you

User avatar
p45cal
2StarLounger
Posts: 142
Joined: 11 Jun 2012, 20:37

Re: trapping empty values

Post by p45cal »

At first glance:
=IF(AND(K14="",TODAY()-H14>42,H14<>""),"6 Week Alert","")