Solved

# If Statement with Multiple conditions

Posted on 2016-08-25

Hi Experts

I have a situation where I need to create an if statement with lots of conditions. I am just not sure

where to start or if this is even the best way to tackle my task.

I have two columns A and B. In each cell is a value A,B,C OR D. In column C I need to create an answer to the following question.

If column A is A and Column B is A then the answer would be "No Change"

If column A is A and Column B is B then the answer would be "Degraded"

If column A is A and Column B is C then the answer would be "Degraded"

If column A is A and Column B is D then the answer would be "Degraded"

If Column A is B and Column B is A then the answer would be "Improved"

If Column A is B and Column B is B then the answer would be "No Change"

If Column A is B and Column B is C then the answer would be "Degraded"

If Column A is B and Column B is D then the answer would be "Degraded"

If Column A is C and Column B is A then the answer would be "Improved"

If Column A is C and Column B is B then the answer would be "Improved"

If Column A is C and Column B is C then the answer would be "No Change"

If Column A is C and Column B is D then the answer would be "Degraded"

If Column A is D and Column B is A then the answer would be "Improved"

If Column A is D and Column B is B then the answer would be "Improved"

If Column A is D and Column B is C then the answer would be "Improved"

If Column A is D and Column B is D then the answer would be "No Change"

Any Help would be greatly appreciated.

Andy