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

Microsoft Excel Tips and Tricks

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

Credit Chester Tugwell