Circular reference confusion

G

Guest

I have the following formula that is carried down XX number of cells
(variable).

I get an error copmlaining about a circular reference which I cannot find.
I am hoping someone smart here could pick it up.

=IF((OR(B11="RB",B11="LB")),IF(I11="VERT",(ABS(IF(A13>0,A13,A14)-A12)/2+ABS(A12-A11)),ABS(A11-IF(A13>0,A13,A14))/2),IF((OR(B13="RB",B13="LB")),IF(I13="VERT",(ABS(IF(A11>0,A11,A10)-A12)/2+ABS(A12-A13)),ABS(A13-IF(A11>0,A11,A10))/2),ABS(IF(A11>0,A11,A10)-IF(A13>0,A13,A14))/2))
 
G

Guest

One more quick question. The formula is listed in the B column, I reference
the A column for the math needing to be done but it seems to still use the B
column cells. is this because of my IF statements (IF(A13>0,A13,A14))?
thanks.
 

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

Top