| 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 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate amount of change in a single cell
On Dec 18, 2:30 pm, DD wrote:
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate amount of change in a single cell
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" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate amount of change in a single 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! "Joel" wrote: 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" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate amount of change in a single cell
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". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Excel won't update/calculate a single cell in a workbook | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
