View Single Post
 
Old 06-24-2019, 11:08 AM
tuix tuix is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2019
Posts: 1
tuix is on a distinguished road
Default 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.
Reply With Quote