[resolved] Easy question (Linear Functions)

[gphelpyfg]

Hi all,

Glad I found this forum, it looks great. I've got a small problem which I imagine is pretty easy for you lot by the looks of things. Any help would be greatly appreciated.

I am trying to come up with a mathematical formula to map the following numbers:

1 to 4
2 to 3
3 to 2
4 to 1

Basically we have a value (1-4) as a given response to a feedback question. The problem is I inadvertantly set 1 to be very satisfied and 4 to be very dissatisfied. This means when I average the feeback back scores, good feedback is displayed as 1 out of 4, rather than 4 out of 4. I can't think of an easy calculation to convert then now the table is populated.

Many thanks for any suggestions.