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
trapping empty values
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: trapping empty values
At first glance:
=IF(AND(K14="",TODAY()-H14>42,H14<>""),"6 Week Alert","")
=IF(AND(K14="",TODAY()-H14>42,H14<>""),"6 Week Alert","")