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

[trevhill]

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

 

[trevhill]

Oh. This is key. I want to be able to change a1...which will then flow through to b1:b3.

 

[AAE]

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)

 

[trevhill]

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".