Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
1. in an unused cell enter 1.15
2. copy the cell 3. Edit PasteSpecial Multiply onto the column -- Gary''s Student - gsnu200790 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a percentage | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Percentage of 1s | Excel Discussion (Misc queries) | |||
percentage | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |