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

Changing a 'Form' Name
I think the fastest way to update a 'sheet' was to create a template so other departments could use the same sheet design and then the attached 'form'. When I saved the new sheet from the 'template' the 'sheet' adjusted the name but the child forms held on to the old name. While I could adjust the 'form' name in the form…
Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…