|
  |
|
|
| Contents | Index Referencing other cells When entering a spreadsheet formula into a Data Editor cell, you may wish to reference another cell within the formula. A cell is addressed by its column label followed by its row number, for example, A12 or B6. If you enter a cell address like A12 into a formula, then copy the formula, the cell address will be updated in the cells you copied into, based on their cell address. For example, if you want a column of numbers to consist of the sum of the two cells immediately above the current cell, you would enter the formula =A1 + A2 into the A3 cell and then copy it into the rest of the cells. When you examine the formula in A4, you will find that it is: =A2 + A3. The original formula has been adjusted to reflect the current cell address. To copy formulas maintaining a constant reference to a cell address, use the $ sign prefixing the column address, row address or both. If you enter a cell address like $A$12 into a formula, the copied formula will include reference to A12 regardless of what the current cell is. If you wish to always get the sum of A1 and A2, you would enter the formula as =$A$1 + $A$2. Warning: If you enter a circular reference into a series of cells, i.e., enter b1 into cell a1 and enter a1 into cell b1, you will see the symbol #Circ appear in the last cell. You must correct the circular reference. There is no way to resolve a series of references that refer to each other. |
|
|
