I should know this....but, how do I add 4% to a range of cells?
(I'm trying to update a price sheet by increasing the % on existing prices)

Thanks!
--
John

1. Type 1.04 in some empty cell.

2. Edit/Copy that cell

3. Select the cells containing the prices

4. Edit/Paste Special and select the Values and Multiply options.


On Wed, 12 Dec 2007 10:10:01 -0800, John <(E-Mail Removed)> wrote:

>I should know this....but, how do I add 4% to a range of cells?
>(I'm trying to update a price sheet by increasing the % on existing prices)

Put 1.04 in a spare cell. Copy, select your range of cells, then Edit/
Paste Special/ Multiply.
--
David Biddulph

"John" <(E-Mail Removed)> wrote in message
news:3E543205-3AE4-434B-8CF5-(E-Mail Removed)...
>I should know this....but, how do I add 4% to a range of cells?
> (I'm trying to update a price sheet by increasing the % on existing
> prices)
>
> Thanks!
> --
> John

put 1.04 in an empty cell
Edit|copy (that cell)
select the range to fix
Edit|paste special|check multiply



John wrote:
>
> I should know this....but, how do I add 4% to a range of cells?
> (I'm trying to update a price sheet by increasing the % on existing prices)
>
> Thanks!
> --
> John

--

Dave Peterson

Enter 1.04 in an empty cell
Copy that cell: Edit>Copy
Select the cells you want to increase
Then, Edit>Paste Special>Multiply>OK

--
Biff
Microsoft Excel MVP


"John" <(E-Mail Removed)> wrote in message
news:3E543205-3AE4-434B-8CF5-(E-Mail Removed)...
>I should know this....but, how do I add 4% to a range of cells?
> (I'm trying to update a price sheet by increasing the % on existing
> prices)
>
> Thanks!
> --
> John

Enter 1.04 in an unused cell.

Copy that cell.

Select the range to change and Edit>Paste Special>Multiply>OK>Esc.

Delete the cell with 1.04


Gord Dibben MS Excel MVP

On Wed, 12 Dec 2007 10:10:01 -0800, John <(E-Mail Removed)> wrote:

>I should know this....but, how do I add 4% to a range of cells?
>(I'm trying to update a price sheet by increasing the % on existing prices)
>
>Thanks!

Thanks! (all) That did it! I knew it was something not too complicated. I
appreciate it.
--
John


"Myrna Larson" wrote:

> 1. Type 1.04 in some empty cell.
>
> 2. Edit/Copy that cell
>
> 3. Select the cells containing the prices
>
> 4. Edit/Paste Special and select the Values and Multiply options.
>
>
> On Wed, 12 Dec 2007 10:10:01 -0800, John <(E-Mail Removed)> wrote:
>
> >I should know this....but, how do I add 4% to a range of cells?
> >(I'm trying to update a price sheet by increasing the % on existing prices)
>