Which formula would I need for this please?

[alexw94]

So I am going through some data. See attached screenshot for what I want to achieve.

Basically, I need the following.

* If Question is Yes and Comment is Yes then completion column will need to be "Yes"

* If Question is Yes and Comment is No then completion column will need to be "Yes"

* If Question is N/A and comment is Yes then completion column will need to be "Yes"

* If Question is N/A and Comment is No then completion column will need to be "No"

* If Question is Not completed and Comment is No then completion column will need to be "No"

* If Question is Not completed and Comment is Yes then completion column will need to be "No"

Based on those 6 scenarios answers for "Question" and "Comment" columns, I need a formula so it can work out correct outcome in the "Completion" column. Thank you.

[#2]

@alexw94 

In D2:

=IF(OR(B2="Yes", AND(B2="N/A", C2="Yes")), "Complete", "Not Complete")

Edited to correct typo

[#3]

This has not worked, the formula doesn't seem to be highlighting C2 meaning it has not been referenced.

[#4 · Accepted solution]

@alexw94

My apologies, the formula contained a typo. I have corrected my previous reply.

[#5]

Perfect, thank you, this has now worked.