In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.
Typically, when you copy a formula that uses references, Excel automatically adjusts the reference in the pasted formula to refer to different cells relative to the position of the formula.
Sometimes when you copy a formula, you don't want one of the cell references to change. Creating an absolute reference—a reference to a cell that does not change when copying a formula—solves this problem. An absolute reference always refers to the same cell or range. It is designated in the formula by the dollar sign ($).
For this exercise, delete the original formulas and start again.