Blank Cell possible with unused Formula??

Posted by Rick on March 28, 2001 6:00 PM

When you have a formula in a cell but the cell is
blank because you haven't linked the data from
that formula, how can I get the cell to stay blank
instead of say 0 or ###ref etc??

Thanks in Advance!

Posted by Jacob Hilderbrand on March 28, 2001 7:24 PM

try this

set up a if statement and for the false value type ""

=if(your code,true value,"")

hope this helps

Jacob

Posted by Dave Hawley on March 28, 2001 8:39 PM

Hi Rick

Just to expand on Jacobs suggestion, this formula will return "" if the SUM result is either and Error or zero.

=IF(OR(ISERROR(SUM(A1:A6)),SUM(A1:A6)=0),"",SUM(A1:A6))

Dave

OzGrid Business Applications