Hi, currently have a formula that based on cells which have dates entered in them, will automatically populate text in a different cell to indicate status of employee hiring actions. The cell that gets populated with "Active" and "Complete" is AA4. The current formula is:

=IF(AND(ISNUMBER(M4),X4=""),"Active",IF(AND(ISNUMBER(M4),ISNUMBER(X4)),"Complete",IF(AND(M4="",X4=""),"","")))

It works perfectly - i now need to add another element to this. I had to add a data validation dropwdown list in Y4 - if the user makes a choice in that column which populates text, and M4 has a date entered, how do i incorporate that into the above so should that occur, AA4 will populate with "Inactive"? I've tried everything I know of to no avail. I'm sure it is simple, but I can't get anything to work. Thanks - Chris