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!