![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
ecxel formula, subtract from |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
vba add and subtract code | phoenixmoto | Word VBA | 6 | 11-06-2018 02:06 PM |
![]() |
Jue92 | Excel | 4 | 11-01-2016 01:45 AM |
Subtract value from one cell into another | otuatail | Excel | 3 | 02-01-2016 03:21 AM |
![]() |
nitemath2 | Excel | 1 | 06-19-2015 01:28 AM |
Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |