Circular References The array formulas used to implement the project management calculations create circular references.
{"Image DocumentName": "Circular ReferencesThe array formulas used to implement the project management calculations create circular references.", "Image ImageDescription": "A circular reference occurs when the value in a cell depends on the value in another cell that, in turn, is dependent on the value in the original cell. Usually, a circular reference indicates a formula contains an error \u2013 and Excel displays a warning telling you so! Occasionally, a circular reference is needed to accomplish a particular task. This is such an occasion. To tell Excel you intend to use circular references: Click Tools, Options. Click the Calculation tab. Select the Iteration option. Click OK.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}