Posted to microsoft.public.excel.misc

external usenet poster

Posts: 17

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mysterious Circular Reference	Randy Ingle	Excel Discussion (Misc queries)	0	July 4th 06 08:54 PM
Circular reference toolbar not working	[email protected]	Excel Discussion (Misc queries)	3	May 29th 06 01:55 AM
Circular Reference error...	Regnab	Excel Discussion (Misc queries)	0	May 22nd 06 01:23 PM
Circular Reference	nastech	Excel Discussion (Misc queries)	1	April 27th 06 12:54 AM
goal seek circular reference	etxrmm	Excel Discussion (Misc queries)	0	March 16th 06 09:56 AM

All times are GMT +1. The time now is 02:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us