Excel Cell

[John]

Is there some way to save the contents of a cell so that when you recalculate
with new data you do not loose the previous data from the last calculation.
[eg. 1st calculation in A1 = 100, (Store the 100 if possible) 2nd calculation
A1 = 50, 3Rd calculation in cell B1 add Stored data 100 and new data in cell
A1.].

 

[Luke M]

You'd have to use VBA, and have a variable store the value.

If you need multiple values, why not write multiple formulas?