ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculation Problem (https://www.excelbanter.com/excel-discussion-misc-queries/99892-calculation-problem.html)

slwaite

Calculation Problem
 
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?


Wiley

Calculation Problem
 
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?



All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com