IF/AND/OR.... Help!

[Mickel79]

I need a little help with multiple if conditions that would apply to the one cell....


I want the cell E1 to change depending on the status of the event I am inputting. E5 will start as an empty cell and any data will be inputted by the user.

If E5 is blank then I want E1 to also be blank

If E5 has a value inputted that is >0 then I want E1 to say "In Progress"

If E5 has the value '0' inputted, then I want E1 to say "Cancelled"

E9 will typically be blank, however if I input a number from E11 and below it will calculate and put the total number of hours the employees worked in E9. Therefore, if the value in E9 is >0 I want E1 to say "Completed"


Thanks for your help!