Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

DIVIDE BY ZERO

SUINS G2016

SUINS G2016 ✭✭

03/18/16 edited 12/09/19 in Archived 2016 Posts

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

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

03/18/16

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)

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…
NETDAYS Formula Question
I have created a formula to track in progress orders by the number of days, =NETDAYS([Date Received]@row, TODAY()) I have the following columns created, Date Received, Date Completed, In Progress Days This is a formula attached to the entire column, but I need cells for orders completed to stop counting as in progress. Is…