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.

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

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 …

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

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This …

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

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

Excel includes several built-in functions—RAND and NOW, for example—that don't use arguments. Following the Function statement, a function procedure includes one or more VBA …