# Getting rid of the dreaded #DIV/0!

When I put in a formula with a division I get #DIV/0! anytime there is a zero or null value, how can this me returned as just blank?

Sample

=SUM(J12/J13)
###### Who is Participating?

Commented:
I would tend towards the rather handy IFERROR as this will capture more errors than just DIV0:

=IFERROR(J12/J13,"")
0

Commented:
You may try to use an IF function like:

=IF(J13=0,0,J12/J13)

Sincerely,

Ed
0

Microsoft MVP ExcelCommented:
Hello,

test the values of the cells first, especially the J13 cell. Also, you don't need to wrap a division into a Sum() function.

=if(J13>0,J12/J13,"")

This formula will only undertake the division if the value in cell J13 is greater than Zero. If it is not greater than zero, it will just return an empty text value.

cheers, teylyn
0

IT ConsultantCommented:
use your formula with IFERROR like this:
=IFERROR(SUM(J12/J13);"")

see in my sample
sample.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.