Subtract from X formula?

		Microsoft Office Forums > Microsoft Excel > Excel
Subtract from X formula?

FAQ

Thread Tools

Display Modes

06-25-2019, 12:03 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 932

1. Into row 1 of some free column enter the formula

Code:

=6-$A1

2. Copy the formula down until row with last entry in column A;
3. Copy all cells with formula. Right-click on cell A1, and select Paste Special and then the option Values from dropdown menu;
4. Delete formulas. It's done!

Tags

ecxel formula, subtract from

« Previous Thread | Next Thread »

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 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
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 07:12 AM.