#Divide by zero error

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

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)

Excluding All Categories with 0s from Dashboard Graph
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…