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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Counting dates in filtered column 1
formula help 8
Transfer data between two tables 3
If the cell is empty, copy the value from a specific cell. 3
Hiding a Zero Result 5
Offset, Match Questiond 7
IRERR nested formula help please 8

Top