IF(AND Query)

[Corleone]

Hi - I have the following formula set up in cell AQ1120 and it returns "Late" which is the cell entry in AP1120
however, all the conditions are met in cell Z1120 (ie the date is greater than 0 but also less than the date in "Period!$O$2
so I would expect it to return "Failed"
Can anyone Assist?


=IF(AND(Z1120<=Periods!$O$2,Z1120>0),"Failed",AP1120)

Can anyone Assist?

Thanks

Im using Excel 365

 

[Joe4]

Are you sure that the entries in Z1120 and Periods!$O$2,Z1120 are valid dates and not dates entered as text?
One easy way to check is with formulas like these:
=ISNUMBER(Z1120)
=ISNUMBER(Periods!$O$2,Z1120)

If either of those formulas return FALSE, then you are dealing with Text and not a true Date.

 

[Corleone]

Are you sure that the entries in Z1120 and Periods!$O$2,Z1120 are valid dates and not dates entered as text?
One easy way to check is with formulas like these:
=ISNUMBER(Z1120)
=ISNUMBER(Periods!$O$2,Z1120)

If either of those formulas return FALSE, then you are dealing with Text and not a true Date.

You have led me in the right direction - Cheers

 

[Joe4]

You are welcome.
Glad I was able to help!