well the formula I gave you says completed based on your uploaded workbook.
I would say that what shows up in E1 will be based on your priorities.
so this gives a blank for if first E5 is blank, then returns completed if E9 is greater than 0
=IF(E5="","",IF(E9>0,"Completed",IF(E5>0,"In Progress","Cancelled")))
it is simply a reordering of the one I gave you in post #2.