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))

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))