Thread: If Functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnnie[_2_] Johnnie[_2_] is offline
external usenet poster
 
Posts: 29
Default If Functions

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