Hello,
I want to show the difference between 2 values.
PROBLEM is.. It's in the same cell.
I get 1 value, and when I click on my commandbutton it changes.
Now I Want to show the difference between these 2 in the Cell below
Q4 = where the value is.
Q6 = where I want the difference to be displayed.
If this is too hard I had another idea:
Showing both Previous and current value.
All I have to do is Current - Previous.
But.. What I want is: Current value is always shown
Then when I click the commandbutton I want the current value to become Previous value and then to show the NEW Current value.
I Hope someone can help me.
I want to show the difference between 2 values.
PROBLEM is.. It's in the same cell.
I get 1 value, and when I click on my commandbutton it changes.
Now I Want to show the difference between these 2 in the Cell below
Q4 = where the value is.
Q6 = where I want the difference to be displayed.
If this is too hard I had another idea:
Showing both Previous and current value.
All I have to do is Current - Previous.
But.. What I want is: Current value is always shown
Then when I click the commandbutton I want the current value to become Previous value and then to show the NEW Current value.
I Hope someone can help me.