If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

=if(yourformulahere=0,"",yourformulahere)



t1202 wrote:

If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

--

Dave Peterson

In say A1
=IF(B1+B2=0,"",B1+B2)
Regards,
Alan
"t1202" wrote in message
...
If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

Either use a formula like =IF(B1-C1=0,"",B1-C1) or surpress all zeros with
ToolsOptionsView and uncheck the Zero Values box

"t1202" wrote:

If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

If the answer to the formula is 0, how can I make it just show the
cell as empty instead of actually putting a 0 in the cell?

One way:
Tools Options View
And un-check "zero values."

Another way:
Format Conditional formatting
and set the font color to the background color when a cell is zero.

Another way:
=IF( <formula=0, "", <formula )

Another way:
Format Cells Number Custom
And put the following for Type:
###;-###;""

(I have Excel 97.)

Jay,

This is a nit, but the pair of quotes isn't really needed, as long as the
second semicolon is there.
###;-###;
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jay" wrote in message
8.16...
If the answer to the formula is 0, how can I make it just show the
cell as empty instead of actually putting a 0 in the cell?

One way:
Tools Options View
And un-check "zero values."

Another way:
Format Conditional formatting
and set the font color to the background color when a cell is zero.

Another way:
=IF( <formula=0, "", <formula )

Another way:
Format Cells Number Custom
And put the following for Type:
###;-###;""

(I have Excel 97.)