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

If test values are in A2 and B2 then use:

=IF(A2=B2,"No Change",IF(A2<B2,"Degraded","Improved")) See also example file attached.

Regards,

Glenn

EE_Q_28965694.xlsx