Subtracting in excel


Using Excel 2013. Windows.

I have a simple excel question

I have a number in column A and I want to subtract for example 30 from it.

What's the easiest way to do that.  Do I have to create a blank column for the formula to work. Or can I just do something in excel that subtracts 30 from everything in Column A?




Rowby GorenAsked:
Who is Participating?
BillBondoConnect With a Mentor Commented:

If A1 was say 45, cell B1 could have that formula and would return 15
jimc1977Connect With a Mentor Commented:
There is no need to create a hidden column.

in the cell that you would the answer  you type "= a1-30"

you can then use the black + sign in the lower right corner to spread the formula down to the other cells you want.
dani gammonConnect With a Mentor Product Operations ManagerCommented:
If you want column A to have the solution,  move your data to column B.

On column A use formula =B1-30.  The output will be the subtraction.  Drag the formula down the column of all the cells you want to subtract. Then, hide column B from showing.
Rob HensonConnect With a Mentor Finance AnalystCommented:
You can use the Paste Special dialog to do this.

Type the value that you want subtracted form your cells in an unused cell and copy it to the clipboard.

Select the range that you want adjusted by this value and activate the Paste Special dialogue.

Select the Subtract radio button and click OK. If the destination cell has a formula it will wrap the existing formula in brackets and append the -30 on the end. If the cell has a value it will just replace the value with the adjusted value.

Rob H
Rowby GorenAuthor Commented:
All of the solutions were excellent and I will keep them in my excel bag of tricks.  In this instance I used y: BillBondo's with the parenthesis.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.