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

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.

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.