increment a cell value, and fix the value

[rpsantos]

I want to be able to have a "cell" value that can be incremented by say
a doller value in another cell, but then have the "cell" value fixed.
This is becuase if I then want to change the new "cell" value by
different dollar amount, I want to be able to use an incremental dolla
amount, and not a total dollar amount.

Example:
"cell" = $10
Input $2 into dollar cell, therfore "cell" changes to $12.

If I then want to add an increase of $4 to make "cell" = $16, I want t
be able to input $4 into the dollar cell instead of $6

 

[Andy B]

Hi

It sounds like you want an accumulator function. Have a look here for some
options:
http://www.mcgimpsey.com/excel/accumulator.html

 

[rpsantos]

Andy,

Thanks for the info. This will work great

 

[Andy B]

Thanks for the thanks!