Excel 2000 question
 

I am trying to add $5 to an existing cell value when the value of a different
cell is modified.

Excel 2000 question
 

What do you mean by modified?

Also any formula can not refer to the value of the cell it is entered in...

You may use Worksheet_Change(ByVal Target As Range)
to update the value

"L Johnson" wrote:

I am trying to add $5 to an existing cell value when the value of a different
cell is modified.

Excel 2000 question
 

Not easily done without using a helper cell because formulas can only pull
and not push.

To do it in-cell you either use a circular reference in A1 with iterations
set to 1 or VBA code.

See JE McGimpsey's site for help on an accumulator with methods for both the
above.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP


On Thu, 5 Feb 2009 14:33:44 -0800, L Johnson <L
wrote:

I am trying to add $5 to an existing cell value when the value of a different
cell is modified.