excel formulas
put .03 in an empty cell
Copy the cell
Select the cells you want to multiply
Use Edit-Paste Special - Multiply
"Brian B" wrote:
I am trying to multiply a row of cells by the same number without making an
additional row with the results. For example:
10
10
10
10
10
All multilplied by3%, thus displaying:
.03
.03
.03
.03
.03
Any way to make this happen without creating an additional row? Can I keep
the original data part of the formula?
Hope this makes sense...THX!
|