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!

1. in an unused cell enter 1.15
2. copy the cell
3. Edit PasteSpecial Multiply onto the column
--
Gary''s Student - gsnu200790

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

"Gary''s Student" wrote:

1. in an unused cell enter 1.15
2. copy the cell
3. Edit PasteSpecial Multiply onto the column
--
Gary''s Student - gsnu200790

The correct way to state it is

13.50 + (13.50 * 15%)

me wrote:

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

"Gary''s Student" wrote:


1. in an unused cell enter 1.15
2. copy the cell
3. Edit PasteSpecial Multiply onto the column
--
Gary''s Student - gsnu200790

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

"me" wrote:

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!

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"me" wrote in message
...
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!

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:

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!