IF and OR statement

**JPSIMMON** · 06-19-2017, 06:58 PM

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** · 06-19-2017, 08:18 PM

Formula:

Please Login or Register  to view this content.

**FlameRetired** · 06-19-2017, 08:23 PM

Try this instead.

Formula:

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.

Formula:

Please Login or Register  to view this content.

**Phuocam** · 06-19-2017, 08:28 PM

Or:

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

IF and OR statement

LinkBack

Thread Tools

Rate This Thread

Display

IF and OR statement

Re: IF and OR statement

Re: IF and OR statement

Re: IF and OR statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] i have an if then statement that works, how to make it work as a with or case statement

nested IF statement or AND? trying to write an IF statement with multiple conditions

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions