Absolute references include the $ symbol before the column letter and before the row number, and always refer to the cell in a specific position in the spreadsheet. Relative references include only the cell’s column letter and row number, and describe where a cell is in relation to other cells of the spreadsheet.
1. | Double-tap the cell, and type the formula. |
2. | Move to the appropriate position in the formula, and type the cell reference. |
Use the format for a relative reference (B3), absolute reference ($B$2), or range of cells (A1:A4).
1. | In a Lists & Spreadsheet page, tap the cell that you want to link to a variable, and then tap the cell again to open the context menu. |
2. | Tap Link, and then tap the name of the variable to insert it into the cell. |
1. | Tap the column formula cell (the second cell from the top) that you want to link to a variable. |
2. | Type the name of the list variable that you want to link to, and then tap return. |
Note: To view a list of available variables, tap var on the TI‑Nspire™ Keyboard.