DIVIDE BY ZERO

SUINS G2016

Hi, how may i obtain 100% when i divide two cell with zero? I am using 0 / 0 and i am obtain DIVIDE BY ZERO.

 

0/0=100%

 

Thank you so much

J. Craig Williams

Dividing a number by 0 is infinity, regardless of what is on top (the numerator).

 

http://mathforum.org/dr.math/faq/faq.divideby0.html

 

What do you expect for 1/0?

 

If you want to ignore the 0, try the IF function.

 

Craig (degree: Bachelor of Science in Mathematics)