SOLVED

# Which formula would I need for this please?

Occasional Contributor

# Which formula would I need for this please?

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.

4 Replies

# Re: Which formula would I need for this please?

In D2:

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

Edited to correct typo

# Re: Which formula would I need for this please?

This has not worked, the formula doesn't seem to be highlighting C2 meaning it has not been referenced.
best response confirmed by alexw94 (Occasional Contributor)
Solution

# Re: Which formula would I need for this please?

@alexw94

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

# Re: Which formula would I need for this please?

Perfect, thank you, this has now worked.