IF Pass Fail Blank query

[Bidds10]

Hello, I’m trying to the find a formula which is will help me to find out which jobs have passed for failed their SLA by dates.

As you can see I have a formula but it is giving me any blanks cells without a date as a pass and I want them as a fail.

Could anyone help please? Thanks

Currently using -

=IF(O2<=N2, “Pass”, “Fail”)

How do I incorporate the blanks as a fail too?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND(O2<>"",O2<=N2), "Pass", "Fail")

 

[Bidds10]

Yes perfect! Thank you so much!

Hi & welcome to MrExcel.
How about

=IF(AND(O2<>"",O2<=N2), "Pass", "Fail")[/COD
[/QUOTE]

 

[Fluff]

You're welcome & thanks for the feedback.