Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate amount of change in a single cell | Excel Discussion (Misc queries) | |||
Formulate a cell to change color when above/below an amount? | Excel Worksheet Functions | |||
SUM (How do i add more than one amount in a single cell) | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions |