Subtract from X formula?
Hello everyone, I am in absolute emergency mode right now, freaking out because I think I messed up big time. The issue is that someone sent me data with survey answers ranging between values 1-5. I put them in an excel sheet to make tables. The issue is, in order for the answers to make sense, they needed to be reversed. However I did not know this, and therefore made a whole excel file of 12 sheets and near 200 tables according these values. Now she tells me that they needed to be reversed.
What I need to know is whether there is a way to convert all cell values into what they become after being subtracted from 6. Example;
Currently the cells are:
A1 = 2
A2 = 4.2
A3 = 3.51
What I need them to be:
A1 = 4
A2 = 1.8
A3 = 2.49
Is there a way to do this? I looked around a bit and fiddled with excel on my own but couldn't figure it out. Things like =6-X obviously don't work. This thing is due in a few days so I would really appreciate to know even if there is no way of doing this so I start redoing the data right now. Thanks for all the help.
|