Google Sheets function reference
Every function, explained with examples you can edit live.
19 of Google Sheets’s 516 functions so far — syntax, realistic worked examples, and the Excel equivalent for each. New functions land every week.
Looking for Excel?Google Sheets financial functions
Financial — 3 functions and counting.
- IPMTCalculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PMTCalculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PVCalculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
Google Sheets logical functions
Logical — 3 functions and counting.
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel
- LAMBDACreates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.LogicalExcel
- LETAssigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times.LogicalExcel
Google Sheets math functions
Math — 3 functions and counting.
Google Sheets statistical functions
Statistical — 3 functions and counting.
Google Sheets filter functions
Filter — 2 functions and counting.
Google Sheets lookup functions
Lookup — 2 functions and counting.
Google Sheets array functions
Array — 1 function and counting.
Google Sheets info functions
Info — 1 function and counting.
Google Sheets text functions
Text — 1 function and counting.