I don't know the correct terminology to use to research how to fix this problem. Please bear with me.

I want to satisfy two If statements, then substitute one of two answers in a cell.

Let's say that cell D11 says "Yes" and D12 Says "No"

How do I create a formula that puts N/A in a cell if D11 is Yes and D12 is No or puts "Correct" in the cell if both conditions are not met?

I know how to do it with one if statement

*=IF(D11 = "Yes", "N/A")* but I can't figure out how to say

If D11 = "Yes" and D12 = "No", "N/A" and, if not, "Correct"

Please help

I want to satisfy two If statements, then substitute one of two answers in a cell.

Let's say that cell D11 says "Yes" and D12 Says "No"

How do I create a formula that puts N/A in a cell if D11 is Yes and D12 is No or puts "Correct" in the cell if both conditions are not met?

I know how to do it with one if statement

*=IF(D11 = "Yes", "N/A")* but I can't figure out how to say

If D11 = "Yes" and D12 = "No", "N/A" and, if not, "Correct"

Please help

## Comment