# multiple a range by the value inside one cell - needs to be dynamic

#### trevhill

##### Board Regular
Hi, I want to multiple a range by the value inside a single cell. All at once

Ex:

Cell A1 = .5

b1 = 10
b2 = 20
b3 = 30

These values are hardcoded into the cells (no formula)

Instead of going into each cell and entering "=10*a1". I would like to simply multiple each value already inside b1:b3 by the value inside a1.

Resulting value is:

b1= 5
b2= 10
b3=15

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Oh. This is key. I want to be able to change a1...which will then flow through to b1:b3.

Please don't create duplicate posts. You asked this question here as well

Select cell A1 and press Ctrl + C to copy the cell.

Select cells B1:B3, right-click and perform a PasteSpecial (Multiply)

Didn't mean to duplicate the post.

Let me ask the question a different way. I know how to "Paste Special" and then "Multiple". This yields an absolute value..when I'm trying to get a formula. In other words.

If I have 10, 20, and 30 "typed" into b1:b3. Using paste special yields "=10*.5"; "=20*.5"; and "=30*.5". However I'm trying to find an easy way to get to this: "=10*A1"; ="20*A1"; and "30*A1".......so that when I change A1, the output in b1:b3 is dynamic.

Currently I have to go into every single cell and change "input" to "input*A1".

Replies
2
Views
118
Replies
5
Views
393
Replies
14
Views
379
Replies
1
Views
145
Replies
1
Views
217

1,203,465
Messages
6,055,574
Members
444,799
Latest member
CraigCrowhurst

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back