If #N/A or 0, then "No". Else "Yes"

[tenthcircle]

Dear all,

I have a column A that contains a date, "0", or #N/A.

I would like a formula to be output in column B that returns "No" if the column A value is "0" or #N/A, and "Yes" if the column A value is a date.

Tried combining if statement, or, and iserror but got all confused.

Appreciate any help here. Thank you!

Best regards,
Leonard

 

[wideboydixon]

Book1
	A	B
1	#N/A	No
2	0	No
3	01/01/2016	Yes
Sheet1

Cell Formulas
Range	Formula
B1	=IF(ISNA(A1), "No", IF(A1 = 0, "No", "Yes"))

WBD

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(1/A1),"Yes","No")

 

[tenthcircle]

	A	B
No
No
Yes

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]01/01/2016[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=IF(ISNA(A1), "No", IF(A1 = 0, "No", "Yes"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



WBD

thank you!!