Comment on page
Reference cells
Reference data in other cells from your formula
To reference an individual cell, use standard spreadsheet notation. The only difference is Quadratic allows negative axes; for negative notation append an
n to the front. Examples:Formula Notation | (x, y) coordinate plane equivalent |
|---|---|
A0 | (0,0) |
A1 | (0,1) |
B1 | (1,1) |
An1 | (0,-1) |
nA1 | (-1,1) |
nAn1 | (-1,-1) |
To reference a range of cells, use the traditional spreadsheet notation that separates two distinct cells using a semicolon as a delimiter, e.g.
A1:D3To reference the value from another sheet simply use the sheet name in quotations.
To reference cell F12 in a sheet named "Sheet 1" from a sheet named "Sheet 2" you'd simply use:
"Sheet 1"!F12
To reference cells F12 to F14 in Sheet 1 from Sheet 2 you'd simply use:
"Sheet 1"!F12:F14