MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Returning Blank Cell

Posted by G Marshall on November 07, 2001 1:49 PM

In Cell A1 I have a figure which I add to the figure in cell A2. In cell A3 I have the formula =A1+A2.

If there is no figure in cell A1, how do I get cell A3 to return a blank cell unless there is a figure entered in A1??

Thanks, any help appreciated.


Posted by Aladin Akyurek on November 07, 2001 1:53 PM

In A3 enter: =IF(A1,A1+A2,"")


=IF(COUNT(A1:A2)=2, A1+A2,"")




Posted by Gerald Marshall on November 07, 2001 1:58 PM

Thanks very much Aladin, your help was very much appreciated

Posted by Mark W. on November 08, 2001 6:28 AM

A cell containing a formula cannot be blank... must contain a value even if it's the empty
or null string, "".