From the Not Just Numbers blog:
This week’s post mostly applies to using the IF function, so if you don’t already know how to use this incredibly powerful function, I would recommend that you read this post from 2010, which is still one of my most popular posts every month:
If you already know how to use the IF function but want to apply multiple criteria, read on.
If you wish to apply more than one condition to your IF statement then you need to decide how you want to combine the multiple criteria. The two main options are:
- All conditions must be true – this uses the AND function
- Any of the conditions can be true – this uses the OR function
If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies “The 5 Excel features that you NEED to know” and “30 Chants for Better Charts”.