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.
I keep still get the #DIV/0 error when the two cells are 0/0.![]()
=IF(OR(ISERROR(AG82/AH82),(AG82/AH82)=0),ERROR.TYPE(7),AG82/AH82)
The output I want is error.type(7)
Plz Help!
Thanks
Bookmarks