How do I mass update formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
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!!
 
You could use Edit > Replace; Find: ~*1.05;Replace:*1.05*1.05
(remember * is a wildcard so use ~* to search for *)
 
That worked - really easy, but I've never used that function before.
Thanks a lot!!!!!!!!!!
 
Back
Top