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.
Gerald
Posted by Aladin Akyurek on November 07, 2001 1:53 PM
In A3 enter: =IF(A1,A1+A2,"")
Alternatives:
=IF(COUNT(A1:A2)=2, A1+A2,"")
=IF(A1,IF(A2,A1+A2,""),"")
Aladin
=========
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...
...it must contain a value even if it's the empty
or null string, "".
