nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

#Divide by zero error

Bill Mercer

I am having trouble with this error and need help with the formula

4 Columns (let's call them A,B, C, F)

Formula used is: =SUM(Column B + Column C)/ Column A

How do I make Column F equal Zero (0) when Column A is equal to Zero (0)

Thanks,

Find more posts tagged with

Comments

JLC

Hi Bill,

I usually wrap these in an IFERROR statement.

So it would read:

=IFERROR(SUM(([Column B]@row+ [Column C]@row) / [Column A]@row), 0)

Hope that helps!

ricki

Would the following formula do what you are looking for?

=IF(A2 = 0, 0, (B2 + C2 )/ A2)

Sign in to join the conversation!

Quick Links

Trending discussions

Update Request Form do we need a license?
Hello, I'm not sure I understand the limit with the new type of licences. If I send an update request through a Workflow. Does the receiver need a License and edit the update request form? Thank You
Automation circling and unsure how
I have automations circling between each other and retriggering. I cannot seem to find how it is taking place. Currently I have approval automations that are separated out in numeric order. Instead of going from one approval to the next, my trigger is a Place in Approval Process Column that changes to the next approval…
What are Smartsheet retention settings
I am being asked what are the standard retention settings for Smartsheet, and are they able to be set by our company, or is this something hard set by Smartsheet? If changeable where is this set?