Please help with what if formula

[RExcelSearch]

This is a work laptop so cant download. But I hope this is simple enough. I need a formula for column D. I need the formula look at both columns B and C. I this need it to return the results, in column D. The
complex issue is it needs to recognize #N/A and values. If there are two #N/A s return #N/A if not return the value in either cell. A what if may not be the most efficient, so what formula produces the outcome would be great. I would like a response today if possible. Thanks

 

[awoohaw]

try:

Book2
	A	B	C	D
1
2		0000011379	#N/A	0000011379
3		#N/A	000989564	000989564
4		#N/A	#N/A	#N/A
Sheet1

Cell Formulas
Range	Formula
C2,B4:C4,B3	C2	=NA()
D2:D4	D2	=IF(ISNA(B2),IF(ISNA(C2),NA(),C2),B2)

 

[rlv01]

If there are two #N/A s return #N/A if not return the value in either cell.

What should the formula return if neither cell contains #N/A?

 

[RExcelSearch]

If both has number maybe say "check"

 

[RExcelSearch]

Let me restate, if both columns have numbers the result should say "recheck"

 

[awoohaw]

=IF(ISNA(B2),IF(ISNA(C2),NA(),C2),"RECHECK")

Book2
	A	B	C	D
1
2		0000011379	#N/A	0000011379
3		#N/A	000989564	000989564
4		#N/A	#N/A	#N/A
5		0000011379	000989564	RECHECK
Sheet1

Cell Formulas
Range	Formula
C2,B4:C4,B3	C2	=NA()
D2:D4	D2	=IF(ISNA(B2),IF(ISNA(C2),NA(),C2),B2)
D5	D5	=IF(ISNA(B5),IF(ISNA(C5),NA(),C5),"RECHECK")

 

[rlv01]

Modifying @awoohaw's formula slightly.

Book2
	A	B	C	D
1
2		11379	#N/A	11379
3		#N/A	989564	989564
4		#N/A	#N/A	#N/A
5		11379	989564	RECHECK
Sheet6

Cell Formulas
Range	Formula
C2,B4:C4,B3	C2	=NA()
D2:D5	D2	=IF(COUNTIF(B2:C2,"#N/A")=0,"RECHECK",IF(ISNA(B2),IF(ISNA(C2),B2,C2),B2))

 

[awoohaw]

Oh, thanks @rlv01 I had an error in my suggestion.

In your suggestion I think the 3rd IF is not necessary:
This works:
=IF(COUNTIF(B2:C2,"#N/A")=0,"RECHECK",IF(ISNA(B2),C2,B2))

Book2
	A	B	C	D
1
2		0000011379	#N/A	0000011379
3		#N/A	000989564	000989564
4		#N/A	#N/A	#N/A
5		0000011379	000989564	RECHECK
Sheet1

Cell Formulas
Range	Formula
C2,B4:C4,B3	C2	=NA()
D2:D5	D2	=IF(COUNTIF(B2:C2,"#N/A")=0,"RECHECK",IF(ISNA(B2),C2,B2))

 

[RExcelSearch]

The formula work. This forum really has the depth and speed that has stud the test of time. Thanks again