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?
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?