How to Incorporate another Element in current formula to Populate Text in another cell

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

Hi, for some reason, it won't work, but the formula makes perfect sense. I'm not getting an error message or anything. The spreadsheet is not locked or anything which I thought could be causing the issue. The only thing I saw was in your formula, after the TEXT entry, X4 was referenced as the ISNUMBER, whereas it should have been M4. Do you have any suggestions? Thanks!