Hello, need some help please on what formula to use to help a calculation.
So basically in column B, there is the answers to question 1.
What I need is...
If the question answer is "Not Answered", "Yes", "No" then I need "N/A" to be auto formulated into cell in Column D.
But then If "Other" is in the answer column, I need that to show two things based on whats in Column C. If a cell in Column B = "Other" and a cell in**"Column C" = "Yes" then the cell in "Column D" needs to say "Yes". And if a cell in Column B = "Other" and a cell in**"Column C" = "No" then the cell in "Column D" needs to say "Not completed".
Bookmarks