Forum Discussion
Solved
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 ...
My apologies, the formula contained a typo. I have corrected my previous reply.
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.
My apologies, the formula contained a typo. I have corrected my previous reply.
- Perfect, thank you, this has now worked.
