Thread: Calculate formula only once.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smunn
 
Posts: n/a
Default Calculate formula only once.

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,


--
smunn
------------------------------------------------------------------------
smunn's Profile: http://www.excelforum.com/member.php...o&userid=29856
View this thread: http://www.excelforum.com/showthread...hreadid=495576

Reply With QuoteReply With Quote