Formulas

[sw0318]

How do I change one formula and have it change all other formulas within a
worksheet that are the same.

Example:

=E3*F3*30*0.0950498

I have this formula in many places within a column. I want to change just
one cell and have the change in all cells with this formula.

 

[Pete_UK]

If you defined that as a named formula, then you could just change the
formula in the definition and the cells that use it would change
automatically.

Alternatively, you could just put that formula in one cell (eg X1) and
then change all occurrences in your sheet to $X$1 (you could use Find
& Replace for this).

Alternatively still, you could highlight all the cells and use Find &
Replace (CTRL-H):

Find what: E3*F3*30*0.0950498
Replace with: your_amendment
Click Replace All

Hope this helps.

Pete

 

[John]

Hi
Go to > Edit> Find, type your formula in > Find What: =E3*F3*30*0.0950498
Replace with: and type the correction. press Find All > Replace All
Regards
John