How Can I: Display "COMPLETE" if a Range of Cells are the Same?

[Sandcastle]

Hi everyone

I have a list of statuses.
When the list reaches "complete" for each item I want to display COMPLETE in another cell.
When the list contains mixed statuses I want to display INCOMPLETE in that other cell.

Hopefully the attached sheet explains: status report.xlsx

Thanks,

[ConneXionLost]

Try this as the homework formula, a similar formula can be written for the classwork:

Please Login or Register  to view this content.

[Sandcastle]

Try this as the homework formula, a similar formula can be written for the classwork:

Please Login or Register  to view this content.

This does exactly what I asked, thank you very much.

Now that I've installed it, I realize that I could make it more complex because some list items and their status are "optional," which should not prevent a "complete" status from being reached. How can I escape these variables?