why giving me N/A?

[daveyc18]

=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

 

[MARK858]

Hi JP, I am not getting that result if the G8 is the result of a vlookup returning #N/A because OR(G8=0,ISNA(G8),AB8>=0) evaluates to OR(#N/A,TRUE,TRUE) which returns #N/A and OR(G8=0,G8=#N/A,AB8>=0) which evaluates to OR(#N/A,#N/A,TRUE) which also returns #N/A.

Please see the results I get below.

Excel 2016 (Windows) 64 bit
	G	H	I	J	K	AB
1			Jonmo	JP1	JP2
2			0	#N/A	#N/A
3
4
5
6
7
8	#N/A					345
Sheet1

Cell Formulas
Range	Formula
I2	=IF(ISNA(G8),0,IF(OR(G8=0,Z8>=0),0,Z8))
J2	=IF(OR(G8=0,ISNA(G8),AB8>=0),0,AB8)
K2	=IF(OR(G8=0,G8=#N/A,AB8>=0),0,AB8)
G8	=VLOOKUP(C8,F13:H24,2,0)

 

[Jon Peltier]

I can't find the workbook I used the other day when I first answered. But I've recreated it in this screenshot.

The formulas I've posted (shown in column D) return #N/A and not zero if there is a #N/A error in G8. It must have been late at night, or perhaps I wrote different formulas than I posted. The Jonmo formula in column E returns zero if G8 is #N/A.