(Msg. 1) Posted: Wed Aug 06, 2008 5:01 pm
Post subject: INCREASE COST COLUMN BY A PERCENTAGE Add to elertz Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
i have a spread shee with a column of my product costs i want to mark up the
whole ncolumn by 25%. please help how do i dom this.
(Msg. 2) Posted: Wed Aug 06, 2008 5:26 pm
Post subject: Re: INCREASE COST COLUMN BY A PERCENTAGE Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In an empty cell somewhere (eg M1) enter the value 1.25. Select M1 and
click <copy>, then move cursor and highlight the cells in the product
costs column that you want to increase. Click on Edit | Paste Special
| Values (check) | Multiply (check) | OK then <Esc>.
All your prices will have been increased by 25%, and you can now
delete M1.
Hope this helps.
Pete
On Aug 7, 1:01 am, bill z <bill z....DeleteThis@discussions.microsoft.com> wrote:
> i have a spread shee with a column of my product costs i want to mark up the
> whole ncolumn by 25%. please help how do i dom this.
>
> bill z.
(Msg. 3) Posted: Wed Aug 06, 2008 8:35 pm
Post subject: Re: INCREASE COST COLUMN BY A PERCENTAGE Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
To make each value 25% larger than it already is... enter 1.25 in a blank
cell somewhere; after pressing Enter, select the cell click Edit/Copy from
the menu bar; then select all the cells you want to mark up by 25% and click
Edit/PasteSpecial from the menu bar; select Multiply from the Operation
section; then click OK.
Rick
"bill z" <bill z DeleteThis @discussions.microsoft.com> wrote in message
news:985AD686-C548-4389-AA38-2B94D21F719F@microsoft.com...
>i have a spread shee with a column of my product costs i want to mark up
>the
> whole ncolumn by 25%. please help how do i dom this.
>
> bill z.
(Msg. 4) Posted: Wed Aug 06, 2008 9:32 pm
Post subject: Re: INCREASE COST COLUMN BY A PERCENTAGE Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"bill z" <bill z RemoveThis @discussions.microsoft.com> wrote in message
news:985AD686-C548-4389-AA38-2B94D21F719F@microsoft.com...
>i have a spread shee with a column of my product costs i want to mark up
>the
> whole ncolumn by 25%. please help how do i dom this.
>
> bill z.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office