$DIV/0!

[Darts via OfficeKB.com]

If I want to divide 2 cells to get an average and there is no # in cell yet
the cell where the fomula reads $DIV/0! I would like that cell to be blank.
how do I write the formula.

my formula reads =(J5/L5) my answer in that cell reads $DIV/0! since i do
not have any data yet

thanks

 

[Dave Peterson]

=if(l5=0,"",j5/l5)
or

If I want to divide 2 cells to get an average and there is no # in cell yet
the cell where the fomula reads $DIV/0! I would like that cell to be blank.
how do I write the formula.

my formula reads =(J5/L5) my answer in that cell reads $DIV/0! since i do
not have any data yet

thanks

 

[Darts via OfficeKB.com]

Thanks Dave works great!!!!!!

=if(l5=0,"",j5/l5)
or

If I want to divide 2 cells to get an average and there is no # in cell yet
the cell where the fomula reads $DIV/0! I would like that cell to be blank.

[quoted text clipped - 7 lines]

 

[Fayyaadh Ebrahim]

Thanks Dave works great!!!!!!

=if(l5=0,"",j5/l5)
or

If I want to divide 2 cells to get an average and there is no # in cellyet
the cell where the fomula reads $DIV/0!  I would like that cell to beblank.

[quoted text clipped - 7 lines]

You can also use:

IF(ISERROR(J5/L5),"",J5/L5)