ExcelBanter - Circular reference confusion

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Circular reference confusion (https://www.excelbanter.com/excel-discussion-misc-queries/102330-circular-reference-confusion.html)

Circular reference confusion

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( A130,A13,A14)-A12)/2+ABS(A12-A11)),ABS(A11-IF(A130,A13,A14))/2),IF((OR(B13="RB",B13="LB")),IF(I13="VERT",(ABS(I F(A110,A11,A10)-A12)/2+ABS(A12-A13)),ABS(A13-IF(A110,A11,A10))/2),ABS(IF(A110,A11,A10)-IF(A130,A13,A14))/2))

Circular reference confusion

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(A130,A13,A14))?
thanks.

"Daiv" wrote:

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( A130,A13,A14)-A12)/2+ABS(A12-A11)),ABS(A11-IF(A130,A13,A14))/2),IF((OR(B13="RB",B13="LB")),IF(I13="VERT",(ABS(I F(A110,A11,A10)-A12)/2+ABS(A12-A13)),ABS(A13-IF(A110,A11,A10))/2),ABS(IF(A110,A11,A10)-IF(A130,A13,A14))/2))