Reference cells
Reference data in other cells from your formula
Last updated
Reference data in other cells from your formula
Last updated
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 |
---|---|
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.
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.
To reference the value from another sheet, use the sheet name in quotations with an !
.
To reference cell F12 in a sheet named "Sheet 1" from a sheet named "Sheet 2" use:
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)