=IF(yourformula=0,"",yourformula)

e.g. +IF(A1-B1=0,"",A1-B1)

Watch this..........0 may be just a formatting issue and you really have
0.0000000123 in the cell.


Gord Dibben MS Excel MVP


On Sun, 7 Oct 2007 14:29:02 -0700, JRID06
wrote:

I am trying to make it so if the result of a formula is 0 it will leave the
cell blank instead of a 0 showing up.

"JP" wrote:

Hello,

Don't type them...?

Sorry, not sure what you are trying to do.



--JP


On Oct 7, 5:11 pm, JRID06 wrote:
How do i make it so Zeros dont show up in excel