Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell in my spreadsheet that I must continously update with a new
number. Example: cell a1 already has a number of 24 and I need to add 12 to the 24 for a total of 36. Is this possible for a formula or cell to automatically calculate the number that is already in a cell with the new number to be put into it to create a new sum? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry. It is called a circular reference. You will have to use another cell
and a formula. "slwaite" wrote: I have a cell in my spreadsheet that I must continously update with a new number. Example: cell a1 already has a number of 24 and I need to add 12 to the 24 for a total of 36. Is this possible for a formula or cell to automatically calculate the number that is already in a cell with the new number to be put into it to create a new sum? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mortgage calculation after a large extra payment | Excel Discussion (Misc queries) | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Problem withe ABS Function | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |