iif question

J

JMorrell

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,
 
Top