View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Wiley Wiley is offline
external usenet poster
 
Posts: 86
Default 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?