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