Calculate amount of change in a single cell

  • Thread starter Thread starter DD
  • Start date Start date
D

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.
 
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.
Click to expand...

No. You need VBA to do that.
 
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.
 
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!
 
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".
 
Back
Top