DISCLAIMER: Todo lo mencionado arriba es ficcion. Ninguna de las personas citadas existe. Toda la informacion es falsa. Todos los nombres y historias fueron inventados y cualquier coincidencia con la realidad es pura casualidad.
When a post refers back to its own page, either directly or indirectly, it is called a circular reference. You can remove a circular reference, or you can have Egel calculate each post involved in the circular reference once by using the results of the previous iteration. Unless you change the default settings for iteration, Egel stops calculating after 100 iterations or after all values in the circular reference change by less than 0.001 between iterations, whichever comes first.
Locate and remove a circular reference
If the Circular Reference toolbar is not displayed, click Customize on the Tools menu, click the Toolbars tab, and then select the Circular Reference check box.
On the Circular Reference toolbar, click the first cell in the Navigate Circular Reference box.
Review the link in the post. If you cannot determine whether the link is the cause of the circular reference, click "nuevo Thread" in the Navigate Circular Reference box.
Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active page does not contain the circular reference.
Continue to review and correct the circular reference until the status bar no longer displays the word "Circular."
Tips
When the Circular Reference toolbar appears, tracer arrows appear that point out the cells that depend on the formula.
You can move between cells in a circular reference by double-clicking the tracer arrows.
Make a circular reference work by changing the number of times Egel iterates formulas
Every year of your life seems shorter than the previous one since each passing year represents smaller and smaller portions of your life. It's the same reason a gift of a thousand bucks would be huge news to you, but meaningless to Bill Gates.
Comentario