Reference cells
Reference data in other cells from your formula
1. Reference an individual cell
To reference an individual cell, use standard spreadsheet notation. The only difference is that Quadratic allows negative axes; for negative notation, append n to the cell reference. Cells are, by default, relatively referenced. Use $ notation to use absolute references.
Examples in the table below:
| Formula Notation | (x, y) coordinate plane equivalent |
|---|---|
| (0,0) |
| (0,1) |
| (1,1) |
| (0,-1) |
| (-1,1) |
| (-1,-1) |
2. Relative cell reference
Individual cells and ranges are, by default, referenced relatively. E.g. copy-pasting A1 to the following two rows will produce A2, and A3 respectively.
To reference a range of cells relatively, use the traditional spreadsheet notation that separates two distinct cells using a semicolon as a delimiter, e.g. A1:D3
Cells in this notation are referenced relatively, so you can drag out a cell to replicate that formula relatively across your selection.
3. Absolute cell references
To perform absolute cell references, use standard spreadsheet notation with $, for example $A$1:D3 - A1 will be copied absolutely and D3 will be copied relatively if you drag to replicate.
3. Reference across sheets
To reference the value from another sheet, use the sheet name in quotations with an !.
Single cell
To reference cell F12 in a sheet named "Sheet 1" from a sheet named "Sheet 2" use:
Range of cells
To reference cells F12 to F14 in Sheet 1 from Sheet 2, use:
Last updated
