How To Use The Excel Functions
OR & AND (Exercise File + Examples)
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Most of Excel’s functions deal with numbers and making calculations with them.
But some functions have a different purpose: they resolve logical statements and display specific values based on the results.
This might sound complicated, but it’s actually pretty simple. And it can be extremely useful.
In this tutorial, you learn all about the function AND and OR 🙂
You also learn how to make them even more powerful by combining them with IF.
First, I show you the basics of the functions – then I show you how to use them in real-world spreadsheets.
Let’s get started!
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.