If then statement for switching numbers [Closed]

Report
-
How do I use the excel to basically score a survey! I want my code to say if qs: # 1 has score 1 then its 4 , if 2 then its 3 , if 3 then it's 2 , if 4 then it's 1. I have already enter all the data. I have questions going down the column and in the row I have 2 patients ID. I want to be able to make a quote and apply it to question # 1 of the whole 20 row ( 20 patients) I hope that makes sense. (It looks something like this):
Qs ID 1 , ID 2 , ID 3 , ID 4
1
2
3
4

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!