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

 

[Scott Huish]

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

If that was an issue, you could do this:
=IF(N(A1),"YES","NO")

This will return the numerical value of A1 and return all text values as 0.

 

[Joe4]

If that was an issue, you could do this:
=IF(N(A1),"YES","NO")

This will return the numerical value of A1 and return all text values as 0.

Or the formula posted in reply 4!


That is one of the great things about Excel - there are often many solutions that will work for the same problem!

 

[Scott Huish]

Yes, the only advantage my formula has though it would allow a 0 in the cell and not be counted as a date.

 

[Joe4]

Yes, the only advantage my formula has though it would allow a 0 in the cell and not be counted as a date.

Good point!
I hadn't thought of that.