I have several cells that have numeric values in them and I need to update
each cell by 5%. How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????
--
Jill

Put 1.05 in an empty cell, copy it select the target cells, Paste
special, Multiply.

Jill wrote:

I have several cells that have numeric values in them and I need to update
each cell by 5%. How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????

You don't need a formula.

Put 1.05 (105%) in an empty cell
edit|copy that cell
select your range to adjust
Edit|paste special|click multiply and values
clear that cell with 1.05 in it.

Jill wrote:

I have several cells that have numeric values in them and I need to update
each cell by 5%. How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????
--
Jill

--

Dave Peterson

Try this

in a cell type 0.05 and copy it.

Select the cells u want to multiply | go to edit | paste special |
values | multiply | ok



On Sep 24, 11:07*am, Jill wrote:
I have several cells that have numeric values in them and I need to update
each cell by 5%. *How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????
--
Jill

That will convert a value of 1 to 0.05. The value to copy is 1.05

muddan madhu wrote:

Try this

in a cell type 0.05 and copy it.

Select the cells u want to multiply | go to edit | paste special |
values | multiply | ok



On Sep 24, 11:07 am, Jill wrote:

I have several cells that have numeric values in them and I need to update
each cell by 5%. How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????
--
Jill