percentage

M

me

Hi,

I have a column with prices and I want to increase 15% to each price.
How do I do this?
Please help ASAP.
Thanks!
 
M

Mike H

Hi,

In a cell enter 1.15 and copy it.

Select the data to multiply them
Edit|Paste Special
Select multiply
Click OK
Delete the cell with 1.15 in

Mike
 
G

Gary''s Student

1. in an unused cell enter 1.15
2. copy the cell
3. Edit > PasteSpecial > Multiply onto the column
 
D

Don Guillett

One way
Sub addtocol()
For Each c In Range("e2:e" & _
Cells(Rows.Count, "e").End(xlUp).Row)
c.Value = c.Value * 1.15
Next
End Sub
 
M

Marcelo

use an axuxiliar cell with 1.15

copy it, and past special - values multiply

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"me" escreveu:
 
Top