divide by zero error

[susancca]

getting the divide by zero error with this formula

=IF(F175=0,0,+F175/L155)

F175=sum of cells equaling 4
L155=sum of cells equaling 0

any help?

 

[Jacob Skaria]

Try

=IF(AND(F175<>0,L155<>0),F175/L155,"")

If this post helps click Yes

 

[David Biddulph]

Firstly you don't need the + before F175/H155
Secondly you don't need to test for F175 being zero, because if F175 is zero
and you divide it by anything non-zero you'll get zero anyway.

What you need to test for to avoid a #DIV/0! error is L155 being zero.
=IF(F155=0,"",F175/L155)

 

[CLR]

"L155=sum of cells equaling 0"...?

Should that be "count of cells equalling 0"?

=IF(ISERROR(IF(F175=0,0,F175/L155)),"",IF(F175=0,0,F175/L155))


Vaya con Dios,
Chuck, CABGx3

 

[Joe User]

getting the divide by zero error with this formula
=IF(F175=0,0,+F175/L155)

It is sufficient to write:

=IF(L155=0, 0, F175/L155)

F175/L155 results in zero naturally when F175 is zero or empty.

 

[susancca]

Thank you very much! this helped tremendously and I can fix my managers
spreadsheet !