calculate amount of change in a single cell
 

Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.

calculate amount of change in a single cell
 

Where would you like the result to be displayed?..........in a pop-up?, in
the cell next to the one changed?, in another sheet?.........

Vaya con Dios,
Chuck, CABGx3



"DD" wrote:

Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.

calculate amount of change in a single cell
 

See your other thread.
--
David Biddulph

"DD" wrote in message
...
Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for
a
function that will show the difference as being 2.

calculate amount of change in a single cell
 

In the cell next to the one changed. A change event macro isn't an option.
Needs to be in a macrofree workbook.

"CLR" wrote:

Where would you like the result to be displayed?..........in a pop-up?, in
the cell next to the one changed?, in another sheet?.........

Vaya con Dios,
Chuck, CABGx3



"DD" wrote:

Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.

calculate amount of change in a single cell
 

Same answer Joel gave to your previous post.

Not without VBA.

At least you got the math right in this post<g


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 11:49:03 -0800, DD wrote:

Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.

calculate amount of change in a single cell
 

didn't mean to post twice... can ya delete this one please?

"Gord Dibben" wrote:

Same answer Joel gave to your previous post.

Not without VBA.

At least you got the math right in this post<g


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 11:49:03 -0800, DD wrote:

Is there a function that will calculate the amount a cell has changed.

For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.