Referring to other cells
Referring to other cells using column name.
You can refer to other cells in the same row by specifying the column name.
In the following screenshot, the formula at the base row uses this technique to
calculate 10 percent of the data at column amount
Screenshot: referring to cells at the same row using column name.
Referring using combination of column name and row number.
You can also refer to other cells, which are not necessary in the same row, by specifying
the column name and row number. This is done using the following syntax:
Screenshot: Specifying column name and row number to refer to another cell
For more information about referring to other cells, see the more about referring to other cells page in the “more details” section.