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.

Please Login or Register  to view this content.

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]

Please Login or Register  to view this content.

[FlameRetired]

Try this instead.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

[Phuocam]

Or:

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