[sdeframond]

In Excel you could use =LET(a; A1; ...) to define a variable 'a' local to the formula. You would have to change A1 in one place only.

I'm not sure this works with LibreOffice though. Probably not.