Matt Pinkston
asked on
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)
Sample
=SUM(J12/J13)
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=IF(J13=0,0,J12/J13)
Sincerely,
Ed