IF function


Excel » Functions » Logical » IF function »

If cell equals value from list

This article demonstrates formulas that check if a cell value is equal to any value in a given list. Table […]

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

IF with OR function

This article shows examples of how to use the IF function with the OR function. Table of Contents IF with […]

If cell contains text

This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]

Use IF + COUNTIF to evaluate multiple conditions

The image above demonstrates a formula that matches a value to multiple conditions, if the condition is met the formula […]

IF function with AND function – multiple conditions

The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]

How to simplify nested IF functions

Nested IF statements in a formula are multiple┬ácombined IF functions so more conditions and outcomes become possible. They all are […]

Find and return the highest number and corresponding date based on a condition

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

How to use the IF function

Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.