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