Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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)
