product function

C

Connie

How do I create a function to multiply the value in each
row of one of my columns by 5% & display the results in
another column. I was able to do it if I go row by row but
there are a lot of rows. Is there an easier way?
 
P

Peo Sjoblom

=A1*1.05

copy down, copy and paste special as values

Where A is the column. Another way, copy the
whole column and paste the values into the other column,
put 1.05 in an empty cell, copy it, select the paste column and do
edit>paste special and select multiply
 
P

Peo Sjoblom

Oops! I realize you might want the percentage, not
to add the percentage, then use

=A1*0.05

or put 0.05 in an empty cell and paste special multiply over the pasted
column
 
Top