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

[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.

 

[Peo Sjoblom]

=IF(linked_cell="","",linked_cell)

 

[gilbert]

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

 

[Gord Dibben]

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

 

[Bill Ridgeway]

Suggest formula

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

Regards.

Bill Ridgeway
Computer Solutions

 

[data_gnome]

Can I use this also in applying to text values?

thanks.

Al Davis

 

[meflorence]

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

 

[data_gnome]

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

Al Davi

 

[gilbert]

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

 

[data_gnome]

Ahh I love it when things work.

Thanks muc