How do I mass update formulas?
 

I am trying to update a lot of formulas on a worksheet with the same factor,
but I'm not sure if I have to update each and every formula, or if there is
some way of doing a mass update in formulas? The normal find/replace doesn't
seem to work!

How do I mass update formulas?
 

Provide a bit more detail,, actual data (sample), etc

"karin Harpering" <karin wrote in
message :

I am trying to update a lot of formulas on a worksheet with the same factor,
but I'm not sure if I have to update each and every formula, or if there is
some way of doing a mass update in formulas? The normal find/replace doesn't
seem to work!

How do I mass update formulas?
 

In an empty cell enter the formula

=1.05

Not just the number 1.05!

Edit|Copy

Select your formulas

Edit|Paste Special, check Multiply

Try on a copy if your workbook first

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"karin Harpering" <karin wrote in message
...
|I am trying to update a lot of formulas on a worksheet with the same factor,
| but I'm not sure if I have to update each and every formula, or if there is
| some way of doing a mass update in formulas? The normal find/replace doesn't
| seem to work!

How do I mass update formulas?
 

For example, if I have the following cells: 1.2*1.05, 1.3*1.05, 1.4*1.05,
1.5*1.05, 1.6*1.05, and I now need to hang another *1.05 behind in each
cell...
Do I need to go into every single cell to do it? I can't copy and paste as
the starting values are different, and replacing just part of the formula
doesn't seem to work.
Thanks a lot!!



"JMay" wrote:

Provide a bit more detail,, actual data (sample), etc

"karin Harpering" <karin wrote in
message :

I am trying to update a lot of formulas on a worksheet with the same factor,
but I'm not sure if I have to update each and every formula, or if there is
some way of doing a mass update in formulas? The normal find/replace doesn't
seem to work!

How do I mass update formulas?
 

You could use Edit Replace; Find: ~*1.05;Replace:*1.05*1.05
(remember * is a wildcard so use ~* to search for *)


karin Harpering wrote:

For example, if I have the following cells: 1.2*1.05, 1.3*1.05, 1.4*1.05,
1.5*1.05, 1.6*1.05, and I now need to hang another *1.05 behind in each
cell...
Do I need to go into every single cell to do it? I can't copy and paste as
the starting values are different, and replacing just part of the formula
doesn't seem to work.
Thanks a lot!!



"JMay" wrote:

Provide a bit more detail,, actual data (sample), etc

"karin Harpering" <karin wrote in
message :

I am trying to update a lot of formulas on a worksheet with the same factor,
but I'm not sure if I have to update each and every formula, or if there is
some way of doing a mass update in formulas? The normal find/replace doesn't
seem to work!

How do I mass update formulas?
 

That worked - really easy, but I've never used that function before.
Thanks a lot!!!!!!!!!!


"Niek Otten" wrote:

In an empty cell enter the formula

=1.05

Not just the number 1.05!

Edit|Copy

Select your formulas

Edit|Paste Special, check Multiply

Try on a copy if your workbook first

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"karin Harpering" <karin wrote in message
...
|I am trying to update a lot of formulas on a worksheet with the same factor,
| but I'm not sure if I have to update each and every formula, or if there is
| some way of doing a mass update in formulas? The normal find/replace doesn't
| seem to work!