#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,

BM

Jaye Casciano

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)