Hi,

I am adding a number to an existing formula on my workbook. I have over
500 entires to update. When I change the first formula and copy and paste
it, all the formulas become the same. How would I be able to make each cells
formula the same and just add the one addition.

Can anyone help ?

Thanks

Medina

Can you give us some exampls of the actual formulas you are dealing with and
what type of number you are adding to it?

"Medina" wrote:

Hi,

I am adding a number to an existing formula on my workbook. I have over
500 entires to update. When I change the first formula and copy and paste
it, all the formulas become the same. How would I be able to make each cells
formula the same and just add the one addition.

Can anyone help ?

Thanks

Medina

ok

the formula is =M5+2.275+.08 the second # (2.275) is different for each
cell. I need to add 5 cents to all the formulas. My only problem is that
the second number in each equation needs to remain different. The only thing
that I need to do is link the 5 cent addition to all the formulas without
having to do each one separately.

Thanks for your help


"tim m" wrote:

Can you give us some exampls of the actual formulas you are dealing with and
what type of number you are adding to it?

"Medina" wrote:

Hi,

I am adding a number to an existing formula on my workbook. I have over
500 entires to update. When I change the first formula and copy and paste
it, all the formulas become the same. How would I be able to make each cells
formula the same and just add the one addition.

Can anyone help ?

Thanks

Medina

What's the variation of the formulas? Can you reply with the first
three cells' formulas?

Thanks