Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-24-2019, 11:08 AM
tuix tuix is offline Subtract from X formula? Windows 10 Subtract from X formula? Office 2019
Novice
Subtract from X formula?
 
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
 

Tags
ecxel formula, subtract from



Similar Threads
Thread Thread Starter Forum Replies Last Post
vba add and subtract code phoenixmoto Word VBA 6 11-06-2018 02:06 PM
Subtract from X formula? Subtract value if cell contains X term 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
Subtract from X formula? How to Subtract value in table, based on two different conditions 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft