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,

BM

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!

Would the following formula do what you are looking for?

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

I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?

I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?

Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…

Help shape the future of Smartsheet. Share your ideas and feature requests.