lundi 1 novembre 2021

Multiple IF statements using dates and blank cells

I currently have a spreadsheet showing when work needs to be complete by (Finish No later than - N2) and the date it was completed by (Actual Finish Date - L2). In the formula I have written it will bring back the words Non Compliant or Compliant if the Actual Finish date was before or after the Finish No later than.

=IF(N2>$L$2,"Non Compliant - Complete","Compliant - Complete")

This works fine but I also need to add two further words based on whether there is any date in the Actual Finish Date column.

Can someone help me add an extra If function to the end of mine with following rules?

If the date is blank and the Finish No later than date is before today then it returns - Non Compliant - Open or If the date is blank and the Finish No later than date is grater than or equal to today then it returns - Compliant - Open

Thank you for looking

Aucun commentaire:

Enregistrer un commentaire