Lists all Excel functions by their category, such as Logical functions or Text functions.

Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

Learn these top skills to create your own formulas and functions.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. …

Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

Lists all math and trig functions, such as the SUM, SUMIF, SUMIFS, and SUMPRODUCT functions.

This new dynamic array behavior can also affect earlier functions that have the ability to return a multi-cell range or array. Below is a list of functions that could return multi-cell ranges or arrays in what we …

To enter another function as an argument, enter the function in the argument box in the Formula Builder or directly into the cell. Enter any additional arguments that are needed to complete your formula.

Lists all logical functions, such as the AND, OR, and IF functions.