In Excel XP complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.
- Type the following information:
In cell A1, type 12345.
In cell A2, type 15865.
In cell B1, type 9347.
In cell B2, type 11942.
In cell C1, type 19348.
In cell C2, type 17103.
- Create the following simple formula:
In cell A3, write a formula to add cell A1 and cell A2.
- Fill the formula in cell A3 to both cell B3 and cell C3.
- Create the following complex formula:
In cell A5, write a formula that divides cell A1 by the sum of cells A3, B3, and C3.
- In the formula defined in cell A5, create an absolute reference to all cells and rows referenced in the following part of the formula: sum of cells A3, B3, and C3.
- Copy the formula and absolute reference in cell A5 and paste it into cell B5 and cell C5.
- Note how the formulas that appear in cell A5, cell B5, and cell C5 differ from one another.