Hi!

=+IF(ISERR(F27/G27),0,F27/G27)

If F27 divided by G27 causes an error, return zero, otherwise, return the
result of F27 divided by G27.

An error will be generated if G27 is blank or a zero, or if either cell
contains text.

You don't need the "+" sign. It's superflous.

=IF(ISERR(F27/G27),0,F27/G27)

Biff

"Trying To Excel" <Trying To wrote in
message ...
I saw this function in a file that was sent to me. The situation called for
a
simple division formula. I dont understand what this formula is saying.