MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding "False" value created by IF command


Posted by Wendy D on January 09, 2001 8:32 AM

I have used the following formula to auto fill the current date when info is put in a different cell
=IF(ISTEXT(A3),TODAY())
The problem I have is that the cell shows "FALSE" until it is made true, and the date appears. How do I hide the "FALSE" word that appears until text is input in the accompanying cell?


Posted by Aladin Akyurek on January 09, 2001 9:01 AM

Change your formula to:

=IF(ISTEXT(A3),TODAY(),"")

Posted by Wendy D on January 09, 2001 9:07 AM

Thanks for your help!!!