$DIV/0!

  • Thread starter Darts via OfficeKB.com
  • Start date
D

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
 
D

Dave Peterson

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

Darts via OfficeKB.com said:
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
Click to expand...
 
D

Darts via OfficeKB.com

Thanks Dave works great!!!!!!

Dave said:
=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.
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
F

Fayyaadh Ebrahim

Thanks Dave works great!!!!!!

Dave said:
=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.
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
Click to expand...

You can also use:

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