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 …

In Excel, from the Home tab, click Conditional Formatting > New Rule. Next, select the “ Use a formula to determine which cells to format ” option, enter your formula and apply the format of …

You can use a formula to determine how Excel evaluates and formats a cell. Open the Conditional Formatting pane and select an existing rule or create a new rule. In the Rule Type dropdown, …

Use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who …

When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's …

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You …

You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values …

When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine which cells to include in the calculations, consider using …

This article describes the formula syntax and usage of the AVERAGEIF function in Microsoft Excel. Description. Returns the average (arithmetic mean) of all the cells in a range that meet …

How to use the COUNTIF function in Excel to count the number of cells that meet values you set.