Hide formulas that = 0
 

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

Hide formulas that = 0
 

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

Hide formulas that = 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), "")




In article ,
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

Hide formulas that = 0
 

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

Hide formulas that = 0
 

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

Hide formulas that = 0
 

One way:

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

In article ,
Sandy 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

Hide formulas that = 0
 

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

Hide formulas that = 0
 

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


In article ,
davesexcel
wrote:

Goto tools options view, uncheck zero values

Hide formulas that = 0
 

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

Hide formulas that = 0
 

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

Hide formulas that = 0
 

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

--
Roger


"JE McGimpsey" wrote:

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