Updating several formulas on a sheet, but not with the same data.

[RFK]

I have a sheet with several formulas that need to be updated.
The old and new formulas are all the same, but with different reference cells in each.
Can I update them all at once?

Here are the first 3 examples, there are a lot more, which is why I don't want to do them individually.

Old formula examples.
=$K9+J16-MAX(J13+J15,J14)
=$K22+J29-MAX(J26+J28,J27)
=$K35+J42-MAX(J39+J41,J40)

Replacement formulas for each.
=$K9+($R9-$Q9)+J16-MAX(J13+J15,J14)
=$K22+($R22-$Q22)+J29-MAX(J26+J28,J27)
=$K35+($R35-$Q35)+J42-MAX(J39+J41,J40)

 

[frabulator]

Use Excel to make a string formula to create your replacements. Then you can drag-and-drop to update numbers much easier.

="A" & M7
="A" & M8

1​		A1
2​		A2
3​		A3
4​		A4
5​		A5

 

[RFK]

Use Excel to make a string formula to create your replacements. Then you can drag-and-drop to update numbers much easier.

="A" & M7
="A" & M8

1​		A1
2​		A2
3​		A3
4​		A4
5​		A5

Thanks for the reply.
I'm not familiar with making a string formula.

 

[frabulator]

I'm not familiar with making a string formula.

A string is programing for text. As an example, if you click in a cell and type

= "Hello there, the value of cell A1 is " & A1

Then it will return the text in that cell of 'Hello there, the value of cell A1 is [A1 value]'

The example I provided above uses this to combine text and values together to make a string.