Thread: #DIV/0!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default #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 ?