How do I stop my formula =IF(D81,NOW(),€�€�) from updating every time I open
the document? I am using this formula for a form that is filled out
electronically; I am using this formula with a locked cell so that the date
and time cant be modified. If I save the document and then reopen it
refreshes every time I do. How can I stop this from happening?

I would use a macro instead of an equation. The macro could continuously
monitor D8 and, when it exceeds 1, set the date/time in a static fashion.

The form of the macro depend on whether D8 is calculated or manually entered.
--
Gary''s Student - gsnu200851


"Shaun" wrote:

How do I stop my formula =IF(D81,NOW(),€�€�) from updating every time I open
the document? I am using this formula for a form that is filled out
electronically; I am using this formula with a locked cell so that the date
and time cant be modified. If I save the document and then reopen it
refreshes every time I do. How can I stop this from happening?

How do I stop my formula =IF(D81,NOW(),"") from updating every
time I open the document? I am using this formula for a form that is
filled out electronically; I am using this formula with a locked cell
so that the date and time can't be modified. If I save the document
and then reopen it refreshes every time I do. How can I stop this from
happening?

One way is to use a circular reference. To allow circular references, use
Tools Options Calculation
and check the "Iterations" checkbox.

Then, if your formula is for A1, try something like this as the formula:
=IF(D81,IF(N(A1)0,A1,NOW()),"")

Adjust to suit.

Caution: allowing circular references can be a risk. Later, if somebody
adds a
circular reference in the workbook by mistake, Excel won't flag it as an
error.