Excel Video 356 offers one more complicated formula, but once that formula works, it’s very powerful. We’re going to do an OR criteria in an array today. If you missed Excel Video 355, please take a minute to watch it first. Today’s video will make a lot more sense.
We’ll build the array step by step in this Excel Video. Remember that for an OR criteria, we add the criteria in the IF statement instead of multiplying. You can add as many OR criteria as you need, all separated by parentheses and added together.
Creating OR criteria is tricky, but once the array works, there a ton of applications. An easier formula next time, I promise. Thanks for watching.
