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

2. Reference a range of cells

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

3. Reference across sheets

To reference the value from another sheet simply use the sheet name in quotations.

Single cell

To reference cell F12 in a sheet named "Sheet 1" from a sheet named "Sheet 2" you'd simply use:

"Sheet 1"!F12

Range of cells

To reference cells F12 to F14 in Sheet 1 from Sheet 2 you'd simply use:

"Sheet 1"!F12:F14

Last updated