percentage

[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!

 

[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

 

[Gary''s Student]

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

 

[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

 

[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:

 

[me]

ok, so just to mek sure I'm doing it right.
what will the anser to:
13.50 + 15%?

 

[Bob I]

The correct way to state it is

13.50 + (13.50 * 15%)