View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fonz
 
Posts: n/a
Default Using the =NOW() Function

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.