If Functions
Hi Johnie,
Try this:
=IF(OR(ISBLANK(G1),(NOW()+14)<G1),"","Review")
Judith
--
Hope this helps
"Johnnie" wrote:
I have the following statement in H#:
=IF((NOW()+14)G#,"Review","""
The problem is that ocassionally there will be not date in the G colum and I
do not want the "Review" to appear in the H colum. How can I change to so
that the cell remains empty if there is no date?
Thanks for your help.
Johnnie
|