Hi all,

This formula works when in adjacent cell, but when I use it in the
intended cell (AM164), I get a circular reference error. Can someone
enlighten me on how to make this work? It seems that I either need to
refer to AM164 differently, or move it elsewhere in the formula. The
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)))))

Thanks


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=559968

try removing the (
,(IF(MATCH
,IF(MATCH
--
Don Guillett
SalesAid Software

"Soundman" wrote in
message ...

Hi all,

This formula works when in adjacent cell, but when I use it in the
intended cell (AM164), I get a circular reference error. Can someone
enlighten me on how to make this work? It seems that I either need to
refer to AM164 differently, or move it elsewhere in the formula. The
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)))))

Thanks


--
Soundman
------------------------------------------------------------------------
Soundman's Profile:
http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=559968

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

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



Soundman wrote:

Hi all,

This formula works when in adjacent cell, but when I use it in the
intended cell (AM164), I get a circular reference error. Can someone
enlighten me on how to make this work? It seems that I either need to
refer to AM164 differently, or move it elsewhere in the formula. The
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)))))

Thanks

--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=559968

--

Dave Peterson

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!


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=559968