ExcelBanter - Using the =NOW() Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using the =NOW() Function (https://www.excelbanter.com/excel-worksheet-functions/93149-using-%3Dnow-function.html)

Fonz

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.

[email protected]

Using the =NOW() Function

You don't need a function, you need to use some VBA
Fonz wrote:
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.

All times are GMT +1. The time now is 04:00 PM.