product function

  • Thread starter Thread starter Connie
  • Start date Start date
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?
 
=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
 
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
 
Back
Top