# Reference cells

Reference data in other cells from your formula

Last updated

Reference data in other cells from your formula

Last updated

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 |
---|---|

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:

`A0`

(0,0)

`A1`

(0,1)

`B1`

(1,1)

`An1`

(0,-1)

`nA1`

(-1,1)

`nAn1`

(-1,-1)