why giving me N/A?

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
440
=IF(OR(G8=0,AB8>0),0,AB8)

g8 is N/a....AB8 is 0.....shouldnt the if statement produce 0? it's giving me N/A
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,882
Office Version
2013
Platform
Windows
N/a is not a zereo !!
If N/a is a possiibility, try
Code:
=IF(OR(G8=0,G8="N/a",AB8>=0),0,AB8)
 
Last edited:

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
so

=IF(OR(G8=0,ISNA(G8),AB8>=0),0,AB8)

or

=IF(OR(G8=0,G8=#N/A,AB8>=0),0,AB8)
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,688
Office Version
365, 2010
Platform
Windows, Mobile
Hi JP, are you getting 0 returned for a #n/a error in G8 with those formula?
 

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
440
ya not working for me...


yah, i know N/A isn't zero, which is why i thought the original formula would work.

in my original formula...i thought excel would be smart enough to decide that if g8 is NOT 0 (which means N/A falls into that category) OR if AB8 is NOT greater than 0, it would directly look at the value of ab8.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
I get 0 from the formula if G8 is #N/A, or if G8 is zero, or if AB8 is > zero. I thought it was funny you'd want 0 if G8 is not zero, but that's the formula you posted.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,509
Messages
5,469,038
Members
406,629
Latest member
Alan365

This Week's Hot Topics

Top