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