About formulas and functions
You enter a formula into a sheet to perform a calculation on numbers, text, or other formulas. When you use formulas, your data becomes dynamic. Functions are built-in formulas that perform specialized calculations automatically. You can use a function by itself as a formula, or combine it with other functions and formulas. Use operators to indicate how the parts of a formula are related.

Array functions
Use this list of functions as a reference for each array function.

Date and time functions
These spreadsheet functions are used for inserting and editing dates and times.

Engineering functions
Use this topic as a reference for the engineering function that is currently supported.

Information functions
This topic contains links to descriptions and examples of the Information functions for use in spreadsheets.

Logical functions
Use this list of functions as a reference for each logical function.

Mathematical functions
Use this list of functions as a reference for each mathematical function.

Spreadsheet functions
Use this list of functions as a reference for each spreadsheet function.

Statistical functions
Use this list as a reference for each statistical function.

Text functions
Use this list as a reference for each text function.