Re: Excel If formula with #N/A data

[ACQ]

Dear excel experts,

Formula is set in column F (F2:F5) to return "blank" or Block. No problem with that.

However, the data set has data which is #N/A.

Have problems in adding parameter if cell A to cell E is #N/A, the cell return "No data"

Book1
	A	B	C	D	E	F
1	A Count	B Count	C Count	D Count	E Block	PHONE BLOCK
2	0	0	0	0	N	Block
3	0	0	X	0	Y	Block
4	0	0	0	0	Y
5	0	0	0	0	Y
6	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=IF(OR(COUNTIF(A2:E2,"X"),COUNTIF(A2:E2,"N")),"Block","")
F6	F6	=IF(E6="#N/A",No Data," ")

Thanks all

 

[number kruncher]

You could use =IF(ISNA(E6),"No Data"," ") in F6

NK

 

[ACQ]

Thanks. It helps.