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













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:

"Sheet 1"!F12

Range of cells

To reference cells F12 to F14 in Sheet 1 from Sheet 2, use:

"Sheet 1"!F12:F14

Last updated