[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Subtracting in excel

Posted on 2014-02-19
Medium Priority
265 Views
Hello,

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?

Thanks

Rowby

thanks

rowby
0
Question by:Rowby Goren

LVL 1

Assisted Solution

jimc1977 earned 480 total points
ID: 39871375
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.
0

LVL 11

Accepted Solution

BillBondo earned 560 total points
ID: 39871378
=(A1)-30

If A1 was say 45, cell B1 could have that formula and would return 15
0

LVL 5

Assisted Solution

dani gammon earned 480 total points
ID: 39871384
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.
0

LVL 34

Assisted Solution

Rob Henson earned 480 total points
ID: 39872960
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.

Thanks
Rob H
0

LVL 9

Author Closing Comment

ID: 39873694
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.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
###### Suggested Courses
Course of the Month18 days, 12 hours left to enroll

#### 834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.