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

How to use the IF function in Excel to make logical comparisons between data values.

For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the AND …

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 …

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.

The following shows an example of using nested IF functions to assign a letter grade to a numeric test score. Copy the example data in the following table, and paste it in cell A1 of a new Excel …

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

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

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