Excel IF Range Contains Value | How to Perform an IF Statement on a Range

Описание: 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file: https://www.bluepecantraining.com/wp-...

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