|
Posted to microsoft.public.excel.misc
|
|
|
Calculate formula only once.
Take a look at
http://www.mcgimpsey.com/excel/timestamp.html
In article ,
smunn wrote:
I have a worksheet that has multiple formulas on it. These formulas
need to update the values as more data is input. However, I have one
formula that I want to only calculate once and then remain as that
value.
Example: =IF(L6="","",NOW())
I want the formula cell to display the time that a value was entered
into L6 and then remain that value.
Thanks,
|