SOLVED

Which formula would I need for this please?

Copper Contributor

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 YesScreenshot 2023-04-06 132055.png 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

@alexw94 

In D2:

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

 

Edited to correct typo

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

@alexw94

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

Perfect, thank you, this has now worked.
1 best response

Accepted Solutions
best response confirmed by alexw94 (Copper Contributor)
Solution

@alexw94

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

View solution in original post