If Functions - ExcelBanter

Posted to microsoft.public.excel.misc

Johnnie[_2_] Johnnie[_2_] is offline

external usenet poster

Posts: 29

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert cell formula functions to code functions	Adnan	Excel Discussion (Misc queries)	1	October 1st 08 08:30 PM
formula/functions for average and if functions	Petu71	Excel Worksheet Functions	2	August 5th 07 08:25 PM
efficiency: database functions vs. math functions vs. array formula	nickname	Excel Discussion (Misc queries)	2	July 14th 06 04:26 AM
Looking for a site with functions that substitute the ATP functions	Franz Verga	Excel Worksheet Functions	3	June 24th 06 04:30 AM
Nesting functions in the functions dialog box	cs170a	Excel Worksheet Functions	0	June 10th 05 10:36 PM

All times are GMT +1. The time now is 08:02 PM.

Menu

About Us