#Divide by Zero Error

Options

Angie F

Angie F ✭✭

02/21/24 in Formulas and Functions

HI! Can someone help me rewrite my formula below to get rid of the #divide by zero error in my sheet? I want it to show a zero. If we have a zero in the formula it would be in the comps column. I'm having issues wrapping my brain around how it needs to look

0 ·

Answers

aamiva ✭✭

02/21/24

=IFERROR([NET HOLD]@row / ([MONEY IN]@row + COMPS@row), 0)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a best practice to convert a dashboard to a PDF?
I've been asked to see if there's a way to make saving a dashboard as a PDF more accurate. I've tried printing/saving as a PDF. Is there a setting so that the area that I have for a list can expand? If our area is too small, then we don't see the entire list. And if we make the area large enough to always contain the…
Autopoluate date information to another cell
I would like to autopopulate a cell in another column with the first 3 letters of the month and the last 2 digits of the year that are in the date column that are now displayed as 07/01/25. Thank you in advance for sharing your wisdom!!
Formula not working - correctly
I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets. I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports…