Getting started

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

Jump to: 👉 Cell references

Jump to: 📜 Formulas cheat sheet

Get started with Formulas the same way as Python. Click or enter / on a cell and select Formulas. This will open the Formulas editor in your browser.

Unlike what you may be used to, Quadratic Formulas are multi-line to encourage readable and re-usable formula structures. E.g. the following Formula that is an example of the multi-line Formula formatting allowed in Quadratic's Formula editor:

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.