Forum Discussion
Solved
Which formula would I need for this please?
Please can someone help me with finding the appropriate formula.
The screenshot is the outcome I need. I need column D to be based on the values in Columns B & C.
I know its an if statement of some kind I need.
formula
In D2:
=IF(OR(B2="Yes", AND(B2="N/A", C2="Yes")), "", IF(AND(B2="Not Completed", C2="Not Completed"), "Not ", "Partially ")) & "Completed"
Fill down.
In D2:
=IF(OR(B2="Yes", AND(B2="N/A", C2="Yes")), "", IF(AND(B2="Not Completed", C2="Not Completed"), "Not ", "Partially ")) & "Completed"
Fill down.
