divide by zero error

  • Thread starter Thread starter susancca
  • Start date Start date
S

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?
 
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)
 
"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
 
susancca said:
getting the divide by zero error with this formula
=IF(F175=0,0,+F175/L155)
Click to expand...

It is sufficient to write:

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

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