IF and OR statement

[JPSIMMON]

I have multiple conditions for my statement and can't seem to get the right output.
I have 2 cells just dividing each other. I want to retrieve #N/A or Error.Type(7) if the calculation retrieves a zero or error.

=IF(OR(ISERROR(AG82/AH82),(AG82/AH82)=0),ERROR.TYPE(7),AG82/AH82)

I keep still get the #DIV/0 error when the two cells are 0/0.

The output I want is error.type(7)

Plz Help!

Thanks

[mehmetcik]

  =if(AG82 =0, "error.type(7)",if(AH82=0,"#N/A",AG82/AH82) )

[FlameRetired]

Try this instead.

=LOOKUP(1E+306,--CHOOSE({1,2,3,4},ISERROR(AG82/AH82),(AG82/AH82)=0,ERROR.TYPE(AG82/AH82),AG82/AH82))

If your are not aware of it the number(s) in ERROR.TYPE are what the function returns when wrapped around an equation.

If what you expect is 7 then enter it as a constant like this.

=LOOKUP(1E+306,--CHOOSE({1,2,3,4},ISERROR(AG82/AH82),(AG82/AH82)=0,7,AG82/AH82))

[Phuocam]

Or:

=IF(OR(N(AG82)=0,N(AH82)=0),"ERROR.TYPE(7)",AG82/AH82)