isna returns a circular reference

S

Soundman

Hi all,

This formula works when in adjacent cell, but when I use it in th
intended cell (AM164), I get a circular reference error. Can someon
enlighten me on how to make this work? It seems that I either need t
refer to AM164 differently, or move it elsewhere in the formula. Th
formula works correctly if I remove the "IF(ISNA(AM164),0," portion.

=IF(ISNA(AM164),0,IF(AM110="n",0,(IF(MATCH("V",C5:C36,0)>1,2,IF(C5="dv",1,0)))))

Thank
 
D

Dave Peterson

Maybe you should just check the portion that causes the error:

=if(iserror(match("v",c5:c36,0)),0,yourformulahere)
 
S

Soundman

Don, Thanks for the help, but the circular reference still was there.

Dave, Yours worked! Thank you! I certainly will learn from this on how
to better handle errors!
 

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

IF(ISNA.. or ISERROR? question.. 3
Circular Reference / OFFSET 3
Inserting current date when number entered in cell & Circular reference error? 4
Reference to another worksheet cell in a sumproduct formula 1
So close and yet so far (IF ISNA question) 3
help with Hyperlink formula setup 1
match with isna formula question 2
Answer to: test/ hyperlink to an Error in a column 3

Top