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