Its on automatic. What does manual do? I tried changing it to that but it
doesn't work either.

"Gord Dibben" wrote:

Paula

Is this the method you're attempting?

You say D4 does not update when you plug a new number into C4.

Is your calculation mode set for automatic or manual?


Gord

On Mon, 12 Jun 2006 11:49:02 -0700, Paula_p
wrote:

Goes like this: =IF(CELL("address")="$C$4",C4+D4,D4)

Enter this in cell D4 and then in ToolsOptionsCalculation check
Iterations and set to 1.

Now when you change the number in C4, D4 will accumulate.