Excel Query- IF formula

[rache47]

Hi, If I have a Date in Column O I want it to return a Yes if there is no date in Column O I want it to return a No- what's the best IF formula to use please, Thanks for your help.
I tried this one =IF(ISNUMBER(O4),"YES", IF(O4="","","NO")) but it returned all Yes

 

[Joe4]

Welcome to the Board!

If it is a valid date, this should work:

=IF(O4>0,"YES","NO")

 

[Scott Huish]

=IF(O4,"YES","NO")

 

[Joe4]

Actually, borrowing the concept from your original one appears to work best:

=IF(ISNUMBER(O4),"YES","NO")

as my original one would return "Yes" for a text entry, while Scott's returns a #VALUE error for text entries.
The formula above will return "NO" for text entries.

 

[rache47]

Welcome to the Board!

If it is a valid date, this should work:

=IF(O4>0,"YES","NO")

Thank you so much that worked

 

[Arts]

=IF(O4,"YES","NO")

Apologies in advance for the silly question, what is the logical test here for the IF statement to return "Yes" ?

 

[Scott Huish]

Apologies in advance for the silly question, what is the logical test here for the IF statement to return "Yes" ?

IF evaluates a TRUE/FALSE expression. Any non-zero number (in this case a date) evaluates to TRUE, and Zero, which a competely blank cell evaluates to, to FALSE.

4/1/2024​	YES
	NO

 

[Arts]

Thank you Scott, (I had always thought the logical expression needed an instruction as such ie >)

 

[Joe4]

IF evaluates a TRUE/FALSE expression. Any non-zero number (in this case a date) evaluates to TRUE, and Zero, which a competely blank cell evaluates to, to FALSE.

4/1/2024​	YES
	NO

Just be aware that it results in a #VALUE error for any text entry.

 

[Arts]

Noted, thanks Joe!