COMP 1010 Lecture Notes - Lecture 35: Circular Reference, Nested Function
Document Summary
If you simply copy the number from d8 to another cell, no relationship would exist and the duplicate would not change if. Copying and pasting is one of the most common causes of errors on a spreadsheet. Formulas keep numbers live, preventing them from getting out of sync when parts change. Excel also allows you to refer to numbers on a different worksheet: e. g. =financials!d8, to duplicate the value from the financials sheet in cell d8 to your current cell. You can also use a more complex formula, e. g. =financials!d8*c7, to multiply d8 on financials with c7 from your current worksheet. The one place you could not use =d8, is in the cell d8 itself: there is no way to calculate the answer. Would occur if you used =d8 for cell c7, and the formula in d8. Follow the order of operations", when to priorities are tied, begin with calculation on left: bedmas = brackets, exponents, division, multiplication,