Hide formulas that = 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that you can keep formulas from showing 0's. I want the
totals to only show when the value is < 0
 
one way:

Format/Cells/Number/Custom ;General;;@

or replace General with your desired format.

You can also use something like:

=IF(<currentformula><0, <currentformula>, "")

For instance, if your formula is

=SUM(A1:A10)

then use

=IF(SUM(A1:A10)<0, SUM(A1:A10), "")
 
You can wrap your formula in an IF statement, such as........

=IF(YourFormula<=0,"",YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
What I have is just a simple @SUM all the way down one column, until the
spreadsheet is completed most of the cells show zeros. The big guy doesn't
want to see the zeros "if there is no data I don't want to see anything.
Well there is no data today but there will be tommorow I don want to have to
cut and paste all these every day.

Does that help
 
One way:

=IF(COUNT(A:A),SUM(A:A),"")

Sandy said:
What I have is just a simple @SUM all the way down one column, until the
spreadsheet is completed most of the cells show zeros. The big guy doesn't
want to see the zeros "if there is no data I don't want to see anything.
Well there is no data today but there will be tommorow I don want to have to
cut and paste all these every day.

Does that help
Click to expand...
 
Note that real 0 data values will also be hidden, and it applies to the
entire workbook.
 
I think I have used
=ISERROR(CELL)
first go to format, then conditional formatting.
Use formula is, type in =ISERROR selcet the range. Then go to format and on
the font colour select WHITE.
I hope this works for you.
 
Back
Top