Need to avoid a circular reference...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Want to display in D5...only...the "answer" to the formula in J5.

If I ask for the value in J5, I create a cicular reference.

Thanks!
 
I'm sorry - it was simple - I just needed to move my request out of the range
of the formula - moved a column and I'm okay!

Thanks!
 
You must log in or register to reply here.

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

Adding cells but leaving blank if not populated 1
SUMPRODUCT formula to include additonal range 8
#N/A in lookup function 3
#Div/0 error, can't get rid of it 8
OR & IF functions 6
@IF Formula 3
I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... 2
Returning Multiple Results with Vlookup 1

Back
Top