Circular Reference

Y

Yunus

How can I avoid Circular reference with this formula...

In Cell J3, =IF(J2=Today(),C3,J3),

ie. if the value in J2 is todays date then in J3 select the value from
cell C3, otherwise leave the value which is in Cell J3 as it is.
 
R

Ron Rosenfeld

How can I avoid Circular reference with this formula...

In Cell J3, =IF(J2=Today(),C3,J3),

ie. if the value in J2 is todays date then in J3 select the value from
cell C3, otherwise leave the value which is in Cell J3 as it is.
Click to expand...

Instead of having the "static value" in J3, put it in some other cell: e.g. K2. Then change your formula to:

=if(j2=today(),c3,k2)
 
Top