Download the featured file: https://www.bluepecantraining.com/wp-content/uploads/2021/06/IF-range.xlsx

In this video I demonstrate how to create an IF formula that performs a test across a range of values rather than a single value.

In the first example, I look to see whether a name is found in a list of names and in the second example I evaluate whether a numeric target has been met within a range of numbers.

The functions featured in this video are: IF, MATCH, COUNTIF and ISNUMBER
------------------------