Make cell value static (unchanged).

[Mykazi]

Hello. I will explain what I need with an easy example.
A1: 10
A2: 20
A3: A1 + A2 = 30
Now if I modify the value of A1, A3 will change of course.
I need some kind of way or formula to keep A3 = 30 (or probably show this value in another cell as long as it remains static) no matter what changes in A1.
It is in a table and needs to be done automatically not manually changed every time.

 

[farmerscott]

HI,

how about turning "calculation" to mannual on the "formula" tab?

FS

 

[Mykazi]

What do you mean?
A1 and A2 get their info from another worksheet.