Lock Cell the entry so it does not change with the 'NOW()' funtion

[toyaht]

I need a formula that will place time and date of an entry on each row separately and not change the previous entry's time and day.
I use an ID number in column A as a reference.
=IF(A5>1;NOW();0) it works but the next row entry changes all previous entries to the current time and date.

 

[lexxie2013]

Have you tried

=IF($A$5>1;NOW();0)

 

[lexxie2013]

Apologies, just re-read post and noticed it was probably a relative reference that you implied. One solution maybe to enter the following. In B5 enter :

=IF(A5<>"",IF(B5="",NOW(),B5),"")

This is a circular function so you would need to change the setting File - Options - Formulas and check allow iterative calculations.

HTH

 

[lexxie2013]

Should have referred to the link that resolved this :

How to insert timestamps in excel sheet using formulas | Chandoo.org - Learn Microsoft Excel Online

and for an explanation of circular functions :

Excel Circular References - What are they, How to use them, Examples & Dealing with Circular References | Chandoo.org - Learn Microsoft Excel Online