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)
Matt PinkstonAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
I would tend towards the rather handy IFERROR as this will capture more errors than just DIV0:

=IFERROR(J12/J13,"")
0
 
MINDSUPERBCommented:
You may try to use an IF function like:

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

Sincerely,

Ed
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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
 
helpfinderIT 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.

All Courses

From novice to tech pro — start learning today.