Hide formulas that = 0

[Sandy]

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

[Sandy]

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" wrote:

>
> Give us an example of the formulas you are using
>
>
> --
> davesexcel
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=522146
>
>

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


In article <davesexcel.24nz4o_1142347205.7588@excelforum-nospam.com>,
davesexcel <davesexcel.24nz4o_1142347205.7588@excelforum-nospam.com>
wrote:

> Goto tools options view, uncheck zero values

[Sandy]

Thanks, never thought of that

"davesexcel" wrote:

>
> Goto tools options view, uncheck zero values
>
>
> --
> davesexcel
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=522146
>
>

[JE McGimpsey]

One way:

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

In article <19509051-5FB0-48B1-8829-7F8453958D8A@microsoft.com>,
Sandy <Sandy@discussions.microsoft.com> wrote:

> 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" wrote:
>
> >
> > Give us an example of the formulas you are using
> >
> >
> > --
> > davesexcel
> > ------------------------------------------------------------------------
> > davesexcel's Profile:
> > http://www.excelforum.com/member.php...o&userid=31708
> > View this thread: http://www.excelforum.com/showthread...hreadid=522146
> >
> >

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




In article <9E7D4E2C-AFB8-4517-8202-20FEA1B5962B@microsoft.com>,
Sandy <Sandy@discussions.microsoft.com> wrote:

> 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

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3



"Sandy" wrote:

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

[Guybon Berry]

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.

"Sandy" wrote:

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