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?
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?
Rounding it off didn't work great as some prices were inconsistent..Manuel entry *** eh