Thread: excel formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default 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!