How do I mass update formulas?

[karin Harpering]

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!

 

[JMay]

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

 

[Niek Otten]

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

|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!

 

[karin Harpering]

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!!

 

[Lori]

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

 

[karin Harpering]

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