If cell contains multiple values
This article demonstrates formulas that perform a partial match for a given cell using multiple strings specified in cells F2 […]

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 techniques to check if a cell contains text based on a list. The first example shows […]

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 use nested IF functions
Nested IF statements in a formula are multiple combined IF functions so more conditions and outcomes become possible. They all are […]