What does this function do =+IF(ISERR(F27/G27),0,F27/G27)

  • Thread starter Trying To Excel
  • Start date
T

Trying To Excel

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.
 
J

JE McGimpsey

It's overkill for eliminating a #DIV/0 error when G27 = 0. The + is just
a superfluous unary plus character that is typically inserted by Lotus
users. It's completely unnecessary in XL.

A better alternative (i.e., that wouldn't mask other errors) is

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

Ragdyer

First of all, the plus sign is unnecessary.
Former users of Lotus tend to habitually use it, since it defined a formula
in Lotus, similar to the equal sign in XL.

What the formula is saying is:
If the division of F27 by G27 returns an error (say G27 was zero), then
return zero, NOT the error.
If NO error is returned, then display the results of the division.
 
B

Biff

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
 
T

Trying To Excel

Thanks, great answer right to the point

JE McGimpsey said:
It's overkill for eliminating a #DIV/0 error when G27 = 0. The + is just
a superfluous unary plus character that is typically inserted by Lotus
users. It's completely unnecessary in XL.

A better alternative (i.e., that wouldn't mask other errors) is

=IF(G27=0,0,F27/G27)
Click to expand...
 
T

Trying To Excel

Solved my problem, Thanks

Ragdyer said:
First of all, the plus sign is unnecessary.
Former users of Lotus tend to habitually use it, since it defined a formula
in Lotus, similar to the equal sign in XL.

What the formula is saying is:
If the division of F27 by G27 returns an error (say G27 was zero), then
return zero, NOT the error.
If NO error is returned, then display the results of the division.
Click to expand...
 
T

Trying To Excel

Thanks for clearing things up

Biff said:
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
Click to expand...
 
Top