excel if now timestamp
1 TopicHow to insert timestamp (IF NOW functions)
Hello all! Im having trouble with inserting timestamp, as is: =IF(A2<>"",IF(B2<>"",B2,NOW()),"") This formula should put timestamp in B2 if any entry in A2 is given, but I got error in result . =IF(A2<>"",IF(AND(B2<>"",CELL("address")=ADDRESS(ROW(A2),COLUMN(A2))),NOW(),IF(CELL("address")<>ADDRESS(ROW(A2),COLUMN(A2)),B2,NOW())),"") And this one should update timestamp in B2 when A2 entry is updated, also error returns. What am I doing wrong, please help.9.3KViews0likes2Comments