Calculate amount of change in a single cell

[DD]

Is there a function that I can use to calculate the amount a single cell has
changed without using VBA?

So if Cell A1 had a 5 in it and someone changed it to 7 I want to show it
changed 3.

 

[Dave F]

Is there a function that I can use to calculate the amount a single cell has
changed without using VBA?

So if Cell A1 had a 5 in it and someone changed it to 7 I want to show it
changed 3.

No. You need VBA to do that.

 

[Joel]

Excel doesn't remember previous values, and if it did it would create a
circular reference. You need a macro to savve the old value into another
cell.

 

[DD]

That's what I was afraid of. I was just hoping there was a way using a named
range or something.

Thanks for the replies!

 

[Herbert Seidenberg]

Not very practical, but just for fun....
Create 2 Option Buttons from Forms,
label them "Lock" and "Capture"
and link them a cell named "Cont".
Deliberately turn on Iterations, max=1.
In a cell named "Store" enter
=IF(Cont=2,IN,Store)
Click "Capture" and then "Lock".
The number in "IN" will be stored in "Store"
and can be compared to the current "IN".