Quadratic Docs
  • Getting started
  • Examples
  • Open Quadratic
  • Quadratic AI
    • Getting started
    • Generate code
    • Generate data
    • Import PDFs
    • Import images
    • Security
  • Connections
    • SQL - getting started
    • PostgreSQL
    • MySQL
    • MS SQL Server
    • Parametrize queries
    • SQL AI assistant
    • Security
    • API requests
    • Request a connection
  • Python
    • Getting started
    • Reference cells
    • Return data to the sheet
    • Packages
    • Make an API request
    • Clean data
    • Charts/visualizations
    • Manipulate data
  • Javascript
    • Getting started
    • Reference cells
    • Return data to the sheet
    • API Requests
    • Charts/visualizations
    • Packages
  • Formulas
    • Getting started
    • AI assistant
    • Reference cells
    • Functions and operators
    • Arrays
    • Criteria
    • Wildcards
  • Spreadsheet
    • Navigating
    • Files
    • Shortcuts
    • Insert/delete rows and columns
    • Data validation
    • Present & share
    • Date-time formatting
    • Browser compatibility
  • Teams
    • Manage your team
    • Private files
    • Collaboration
    • Embedded sheets
  • Import data
    • SQL connections
    • API requests
    • Drag and drop .CSV
    • Drag and drop .Parquet
    • Import Excel files
  • Self hosting
    • Getting started
    • Docker
    • AWS
    • Azure
    • Google Cloud Platform
    • Bring your own AI
    • Other hosting
  • Quadratic for Education
    • Overview
    • Enrolling in the education plan
    • Teachers
    • Students
    • Researchers
    • Education FAQ
  • Company
    • About
    • Quadratic is source available
    • Brand assets
  • GitHub
  • Blog
  • Twitter
  • Discord
Powered by GitBook
On this page
  • 1. Reference an individual cell
  • 2. Relative cell reference
  • 3. Absolute cell references
  • 3. Reference across sheets
  • Single cell
  • Range of cells

Was this helpful?

  1. Formulas

Reference cells

Reference data in other cells from your formula.

PreviousAI assistantNextFunctions and operators

Last updated 1 year ago

Was this helpful?

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

A0

(0,0)

A1

(0,1)

B1

(1,1)

An1

(0,-1)

nA1

(-1,1)

nAn1

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

"Sheet 1"!F12

Range of cells

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

"Sheet 1"!F12:F14