Excel help

[lee20010]

Hi, I've had to do some figures for work, I've not used Excel in a number of years and have completely forgot how to create functions etc.

My question is (if I remember right) You can change the numbers in the boxes, this is my current sheet broken down


100 93
77 70
93 86
73 66
77 70
77 70

145 135
168 158
190 180
216 206


and it goes on. But what I need to do, is times each number by 2.1 so for example 100 x 2.1 = 210 which is the new figure, I have about 2000 numbers and I just want a simple command to change every value at once as they are in the same section (D and F). Can it be done? If so how?

 

[wonko]

One way to do this is without using functions is:
enter the value 2.1 into a cell out of the way
select and copy that cell
highlight the range of cells with the values you want to multiply by 2.1
then Edit, Paste special, Multiply, OK

Using formulas, I'd use two extra columns to hold the source values multiplied by 2.1. So on the top row, enter the formula "=A1*2.1" (changing A1 to the row/column of the first cell of data), and then copy that formula down the appropriate rows.

 

[lee20010]

Nice one, right now I've got this

Original



£100.00 £93.00
£77.00 £70.00
£93.00 £86.00
£73.00 £66.00
£77.00 £70.00
£77.00 £70.00


New


£210.00 £195.30
£161.70 £147.00
£195.30 £180.60
£153.30 £138.60
£161.70 £147.00
£161.70 £147.00

Is there a way I can now change them to the nearest 9? So 161.70 = 159 and 147 would = 149

 

[wonko]

You'd need formulas for that... something like "=ROUND(A1/9,0)*9"

 

[lee20010]

Okies, thanks for the help and time saving Rounding it off didn't work great as some prices were inconsistent..Manuel entry *** eh