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 Excel functions by their category, such as Logical functions or Text functions.

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.

Lists all logical functions, such as the AND, OR, and IF 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.

By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue.

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.

Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

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.