Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Reference
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.... . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Reference
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" wrote in message ... 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.... . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Reference
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" wrote in message ... 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.... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Reference | Excel Programming | |||
Circular Reference | Excel Discussion (Misc queries) | |||
circular reference | Excel Discussion (Misc queries) | |||
circular reference when using a UDF | Excel Programming | |||
Circular reference | Excel Programming |