The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much …

How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.

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

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

Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions may …

Sometimes, when you manually hide rows or use AutoFilter to display only certain data you also only want to sum the visible cells. You can use the SUBTOTAL function. If you're using a total row in an …

This article describes the formula syntax and usage of the FIND function in Microsoft Excel. FIND locates one text string within a second text string, and return the number of the starting position of …

These functions aren't available in earlier versions. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 …

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …

Lists Text functions, such as the Clean, Proper, and Trim functions.

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional …