I am sure it is very easy but today I have spent too long on this and cannot work it out.
Appreciate someone helping me out.
I have Two Columns 'Q and R':
In 'Q and R' I can have Valid or Invalid.
I need a formula that says:
IF Q is the same as R answer is Desk
IF Q=Valid and R=Invalid answer is Okay
IF Q=Inalid and R=Valid answer is Recall
Please make my day.