Hide formulas that = 0

[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

 

[davesexcel]

Give us an example of the formulas you are using

 

[JE McGimpsey]

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), "")

 

[Guest]

You can wrap your formula in an IF statement, such as........

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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

 

[JE McGimpsey]

One way:

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

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

 

[davesexcel]

Goto tools options view, uncheck zero values

 

[JE McGimpsey]

Note that real 0 data values will also be hidden, and it applies to the
entire workbook.

 

[Guest]

Thanks, never thought of that

 

[Guest]

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.

 

[Roger]

Thank you very much for your reply. I was just looking for this answer.