PC Review


Reply
Thread Tools Rate Thread

changing numbers in a column by a percentage

 
 
hwalders
Guest
Posts: n/a
 
      31st May 2007
I have a column of product prices and want to increase all prices in that
column by 10%. I'm new at this and sure could use some help.

Thanks


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      31st May 2007
put 1.1 in an empty cell
Edit|copy that cell
Select the range to adjust
edit|Paste special|check multiply
clear that cell with 1.1 in it.



hwalders wrote:
>
> I have a column of product prices and want to increase all prices in that
> column by 10%. I'm new at this and sure could use some help.
>
> Thanks


--

Dave Peterson
 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      31st May 2007
I would personally use a help column, format it as currency then a formula
like

=A2*1.1


then copy down as long as needed, finally copy the new column and paste
specials as values in place

Another alternative

put 1.1 in an empty cell, format it as currency, copy it and select the
column with prices and do edit>paste special and select multiply




--
Regards,

Peo Sjoblom


"hwalders" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a column of product prices and want to increase all prices in that
>column by 10%. I'm new at this and sure could use some help.
>
> Thanks
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a percentage to a column of numbers hld Microsoft Excel Worksheet Functions 3 5th Sep 2008 12:40 AM
Percentage of a Column of numbers Richard Microsoft Excel Misc 1 9th May 2008 01:32 AM
Add percentage to a whole column of numbers =?Utf-8?B?Vk9MVk9SYWNy?= Microsoft Excel Misc 1 21st Aug 2007 03:18 AM
Increasing numbers in a column by percentage =?Utf-8?B?ZGVrYXJl?= Microsoft Excel Worksheet Functions 1 29th Dec 2005 08:45 PM
update all numbers in a column by a percentage Dan Crowson Microsoft Excel Worksheet Functions 2 8th Dec 2003 03:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:02 AM.