How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by …

Use AND and OR together or with the IF function. For example, calculate who earns a commission or find data that meets multiple conditions.

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 …

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 …

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. …

You can work with sample data and formulas right here, in this Excel for the web workbook. Change values and formulas, or add your own values and formulas and watch the results …

The parts of the formula displayed in the Function Arguments dialog box reflect the function that you selected in the previous step. If you selected IF, the Function arguments dialog box …

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.