Lock Cell the entry so it does not change with the 'NOW()' funtion
Results 1 to 4 of 4

Thread: Lock Cell the entry so it does not change with the 'NOW()' funtion
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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.

  2. #2
    Board Regular
    Join Date
    Nov 2013
    Posts
    225
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Have you tried

    =IF($A$5>1;NOW();0)
    A fool is not someone who makes a mistake. A fool is somebody that repeats one.

  3. #3
    Board Regular
    Join Date
    Nov 2013
    Posts
    225
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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
    A fool is not someone who makes a mistake. A fool is somebody that repeats one.

  4. #4
    Board Regular
    Join Date
    Nov 2013
    Posts
    225
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    A fool is not someone who makes a mistake. A fool is somebody that repeats one.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •