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

If you need multiple values, why not write multiple formulas?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John" wrote:

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.].