No, you can not do that without using VBA. Any formulas can't have a
reference to the cell where the formula resides. a simple formula like
=R7+1 in R7 can not return a correct value.
Keiji
Bruce A. Julseth wrote:
> Your suggestion didn't work but it's my fault.
>
> Why is it my fault? Because I failed to mention that the formula resides in
> R7. So, the circular reference still exits.
>
> So the situation is:
>
> - The formula resides in R7
> - If the values at P7 and O4 are NOT equal I want the formula to return
> a blank.
> - If the values at P7 and O4 are equal, I need to test if the value in
> R7. If it's blank, I want to set it to "NOW()".
> If it's NOT blank, I don't want to change it.
>
> So, the formula I created was =IF(P7=$O$4,IF(R7="",NOW(),R7),"")
>
>
> Can I do this WITHOUT dropping into VBA?
>
> Thanks for your help..
>
>
> "Ryan H" <(E-Mail Removed)> wrote in message
> news:4F96794E-1E8E-47E7-87D0-(E-Mail Removed)...
>> 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....
>>>
>>>
>>> .
>>>
>
>
|
Similar Threads
