Learn how to use the IFS function in Excel to check multiple conditions and return a value based on the first TRUE condition. See examples, syntax, technical details and related 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 formulas.

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

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

Date and time: Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. This function is not available in Excel for the web.

In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

Returns the minimum value among cells specified by a given set of conditions or criteria. Returns the k-th percentile of values in a range, where k is in the range 0 to 1, exclusive.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Let's look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it's time to use another tool in your Excel arsenal.

This article describes the formula syntax and usage of the AVERAGEIFS function, which returns the average (arithmetic mean) of all cells that meet multiple criteria.