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.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed …

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

Lists Text functions, such as the Clean, Proper, and Trim 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.

A custom function must start with a Function statement and end with an End Function statement. In addition to the function name, the Function statement usually specifies one or more arguments.

Check if a cell has any text in it To do this task, use the ISTEXT function. Check if a cell matches specific text Use the IF function to return results for the condition that you specify. Check if part of a …

Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its …

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

This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows.