Using the =NOW() Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the =NOW() Function, anytime I make any entries on the sheet, all
of the cells with the function automatically update. Currently, this is the
formula I have from one of the cells:

=IF(F2=0,"",NOW())

WHat should I be adding to it so it doesn't automatically update after a
date and time has been put into place in the cell this formula occupies?
Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell =Now() << Can I get this to auto-update? 2
Automatic Upate of NOW() function? 2
IF formula, Partial word, SUM function as result 1
Excel VBA 1
want to track time while paste value in multiple column of same roe 1
Excel formula to incrementally increase a value by 1 every 365 day 2
Auto Sum Function 3
Difference between NOW() and TODAY() 2

Back
Top