View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce A. Julseth[_2_] Bruce A. Julseth[_2_] is offline
external usenet poster
 
Posts: 29
Default Circular Reference

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....