Thread: iif question
View Single Post
  #1   Report Post  
JMorrell
 
Posts: n/a
Default iif question

This should be an easy one for you gurus...

I a cell, I have a NOW() function that keeps updating everytime a value
changes.

=IF(F22 = "","",NOW())

Isn't there a way to capture the date/time and "lock it" so that it doesn't
change? I'm keeping track of user input date & time values.

tia,
--
JMorrell