If Functions

[Johnnie]

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

 

[Jacob Skaria]

=IF(AND(G10<>"",NOW()+14)>G10,"Review","")

If this post helps click Yes

 

[JudithJubilee]

Hi Johnie,

Try this:

=IF(OR(ISBLANK(G1),(NOW()+14)<G1),"","Review")

Judith

 

[Johnnie]

Judith,
It works great. Thanks so much!
Johnnie

Hi Johnie,

Try this:

=IF(OR(ISBLANK(G1),(NOW()+14)<G1),"","Review")

Judith

 

[Johnnie]

Judith,
It works great. Thanks so much!
Johnnie

Hi Johnie,

Try this:

=IF(OR(ISBLANK(G1),(NOW()+14)<G1),"","Review")

Judith

 

[Johnnie]

Thanks Jacob.
Johnnie

=IF(AND(G10<>"",NOW()+14)>G10,"Review","")

If this post helps click Yes