How to have the word COMPLETED appearing when all aswers are YES

[pleasebepatient]

Hi everyone,

first time here! I'm new to the world of Excel, and I need to create tracking spreadsheet for work. Everyday I received an email with the data from a web-form filled-up online by participants. I cut and paste the data (text) into my spreadsheet. I've created a Macro to transpose the data into a list were I can keep track of who has done what.

To ensure that all answers from the web-form are completed, I've put in cells C9 to C19, this: =IF(B9=B42,"YES","NO") where I've pasted in B9 to B19 the answer from the email and where B42 to B52 contain the exact answer participants are supposed to chose. So in C9 through C19, I have a bunch of Yes and No.

What I want to do at this point, is to have in cell D2 the word "COMPLETED" if all cells from C9 to C19 say YES, and INCOMPLETE if any of the answers are NO.

Any idea how to do this?

[Jonmo1]

Try

=IF(COUNTIF(C9:C19,"No"),"Incomplete","Complete")