# 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