Getting started

Work with classic spreadsheet logic - math, references, and point and click manipulation for quick data analysis.

Get started with Formulas the same way as any other spreadsheet - click = on a cell and get started right away. Formulas are in-line by default.

In-line formulas in Quadratic

You can also optionally use multi-line Formulas for those Formulas that need to be expanded to become readable.

To open the multi-line editor either use / and select it in the cell type selection menu or use the multi-line editor button from the in-line editor as showed below.

The multi-line editor becomes useful when Formulas become more difficult to read than the space afforded by the in-line editor. Example:

IF( Z0 > 10, 
    IF( Z1 > 10, 
        IF (Z2 > 10, 
            AVERAGE(Z0:Z2), 
            "Invalid Data",
        ),
        "Invalid Data", 
    ),
    "Invalid Data", 
)

Cells are by default referenced relatively in Quadratic. Use $ notation to do absolute references, similar to what you'd be familiar with in traditional spreadsheets. Learn more on the Reference cells page.

Jump to: 👉 Reference cells

Jump to: 📜 Formulas cheat sheet