#DIV/0!
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))
"Ken" wrote:
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 ?
|