Calculation using spreadsheets

You can add functions to the spreadsheet in order to perform calculations, for example. Different formulas are available to you, depending on whether you are editing a model of the Spreadsheet type, a results table of a query, or an ad hoc analysis.

Topics

Insert formula

Insert formula directly

Correct error(s) in formulas

Use relative cell references

Use fixed cell references

Work with cell references across sheets

Calculate with physical constants