Excel calculation question

[blue-eye-boy]

I'm using openoffice, but I suppose it will work the same as in microsoft etc. In column A there are a value in each cell downwards, more or less 30 of them. Now in column B, I want each cell to calculate from it's corosponding cell in column a, to add 150 in the same cell in column b. For example, Column b cell 1 = column a cell 1 + 150, and so on until cell 30.

Hope I explain myself good enough? I know what formula to use if I do it one by one, but I get this regularly, and it takes time.

 

[spiderz]

put this in b1
+a1+150

copy and past all the way down

 

[Azbubu]

1) Click on B1
2) type = A:A + 150
3) drag that all the way down

 

[Azbubu]

put this in b1
+a1+150

copy and past all the way down

Then all the B cells will have the same value. I think it should be a:a

 

[InvisibleJim]

If I've understood your question, the answer is about relative versus absolute referencing. If you use relative references in your formula, when you copy the formula to another cell, it will adjust accordingly.

Assume your data is in A1:A30 and your calculations will be in B1:B30

In cell B1 enter the formula =A1+150 ad hit enter.

Click on Cell B1 so that the border is highlighted in bold.

You will notice a small square on the bottom right of cell B1 - Click on this and drag the selection down column B so that all the cells where you want your answer are selected. This will copy your formula into the selected cells.

If you click on Cell B2, you should see the formula is =A2+150, B3 should be =A3+150

The above is relative referencing. If you use absolute references in a formula then the formula will always reference the same row and/or column no matter where you copy the formula. If you enter formula C1 =$A$1+150 then copy down, you will see every cell in column C references cell A1.

 

[gregmcc]

Then all the B cells will have the same value. I think it should be a:a

Nope - that is correct. B1 will have "+A1+150", B2 "+A2+150" etc etc.

 

[Azbubu]

Ok I click on the cell instead of type which is why it shows a:a

 

[blue-eye-boy]

Ok I click on the cell instead of type which is why it shows a:a

Sho, that was fast. Thanks guys, copy and paste worked fine for a start. Will definitely make my life much easier.

 

[Tim the Techxpert]

Hi There,
Spiderz answer will work fine.
may I suggest that you go look at bookboon. They have free excel training manuals which may help you in understanding spreadsheets

Regards

Tim

 

[reneg8or]

in column B: +a1+150 should do this, just copy and paste this down.

LibreOffice is a much more refined fork of OpenOffice and also way less buggy and quirky. I can recommend it.