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?

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"susancca" wrote:

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?

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

"David Biddulph" wrote:

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)
--
David Biddulph


"susancca" wrote in message
...
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?


.