Hiding the "0" in a column with a formula without a value

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

Is there a way to hide the "0" which appears after a
formula is put into a column containing columns without
any value? For example, if I'm in column A3 and I put
the formula in to add A1 and A2, a "0" then appears in
A3. Of course, when a value is entered into either A1 or
A2, A3 then changes to the correct sum. I was wondering
if there is a way to hide the "0" when no values are in
the columns contained within that formula, but the number
appears once values are put in?

Thank you.
 
Hi Brett,

This should be able to cater for your problem :-

in cell A3 : =if((sum(A1:A2)=0,"",sum(A1:A2))

HTH.

Rgds,
Gilber
 
Brett

Ususally with an IF formula.

A1 is empty, A2 is empty

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

The "" will make the cell look blank if results are 0

OR you can go to Tools>Options>View and uncheck "zero values", but there may
be times you would like zeros to show.

Gord Dibben Excel MVP
 
Suggest formula

=IF(SUM(A1:A2)=0,"",SUM(A1:A2)

Regards.

Bill Ridgeway
Computer Solutions
 
You can use "" to represent a blank cell. If Cell A1 contained "Test
the following formula in A2 would return "Test" or nothing if cell A
was blank:

=IF(A1="","",A1)

Best,

Mik
 
Thanks for that.
I see that successfully suppresses the #VALUE! error message if th
field is left blank.

Al Davi
 
Hi Davis,

Sure u can replace with text values, just substitute the blank with
text but you it need to be in inverted commas (" ").

For example.

=if(sum(A1:A5)>=0, "Error", sum(A1:A5))

Hope that helps.


Rgds,
Gilber
 
Back
Top