Ill do my best to explain this...

I have an online form that I have created with Google forms - The form is set up as a

1=Almost Never
2
3
4=Almost Always

and they rate the question 1-4 - After the questionnaire has all been answered then the results are automatically transferred to an good excel document - A made a second tab on the excel document and I am adding certain questions off the results page in to certain categories on the 2nd tab.

I have no problem when I do =SUM and click on the cells i need to be added together from the results page - However some of the questions need to be reversed meaning
1-Almost Always
2
3
4-Almost never

This is to ensure the honesty of their answers -

Now when I go back to those certain questions -
Is there some kind of
=IFC2=1 than it equals 4 formula of some kind??
and if there is do i need to
say that 4 times with all the numbers in that one formula on that cell
I am new to Excel and am trying this out- If anyone could help me out I would appreciate it

thanks for your patience and time!