The FALSE condition of the IF Function is optional. Try:

=IF(P7=$O$4,IF(R7="",NOW()),"")

Hope this helps! If so, let me know, click "YES" below.

--
Cheers,
Ryan


"Bruce A. Julseth" wrote:

I want to use a formula like the following:

=IF(P7=$O$4,IF(R7="",NOW(),R7),"")

The reference to R7 to the false condition gives me a circular reference. I
expected this. What I want to do is leave the Cell unchanged if there is
something in it already (false condition).

How can I do this?

Thanks....


.