if statement fix.xlsx

Hi all.

I hope someone can help.

I am trying to return a value open or closed in a cell depending on if a item is completed or not. The problem is I want the task to be "closed" if all the cells in the range contain completed or N/A. I can only get the formula to work if all the cells say "Completed"

Can anyone help me get the cell to read "Closed" when seeing "Completed" or "N/A"



Attached Example (C3 should say completed because card 1 through card 4 is either completed or N/A). C4 and C5 are working correctly.

1st line has attachment