| Home | Overview | More details | Examples | Download | Faq |
| Overview |
|
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: column_name[row_number] .  Screenshot: Specifying column name and row number to refer to another cell. More info For more information about referring to other cells, see the more about referring to other cells page in the "more details" section. |
|
|