Download the featured file: [ Ссылка ]
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
------------------------
Ещё видео!