#DIV/0!

[Ken]

I know #DIV/0! is a common error but I can't seem to make my formula work
with the ISERROR statement.

My formula is returning a 0/0 value

=IF(I26,(G26+H26))/(I26-F26)


What am I doing wrong in this error correction statement

=IF(ISERROR(I26,(G26+H26))/(I26-F26)),0,(I26,(G26+H26))/(I26-F26))


It keeps telling me I entered too many arguments for this function. What am
I doing wrong ... or is there another way to do this ?

 

[akphidelt]

Well first off your formula is a little messed up... you are asking it

If I26 then do this formula.

What are you trying to do here, the first part of the if statement should be
your equation. So it should look like this, if this is actually what you want
to do

If(Iserror((G26+H26)/(I26-F26)),I26,(G26+H26)/(I26-F26))

 

[Peo Sjoblom]

You only need to test for divide by zero so just test

=IF(I26-F26=0,0,your formula)

btw your formula looks a bit strange

although you can use

=IF(cell,do this,do that)

it is not the normal way to handle if functions

Anyway it is really not necessary to use iserror since you can test for zero
instead
and iserror would hide if you have another error in one of the cells

--


Regards,


Peo Sjoblom

 

[Ken]

Thanks! That worked.

I knew I was doing something goofy...just needed a little push or maybe slap
in this case.

Thanks again.