Instructor: All right, first off,
congrats on finishing section two.
I'm proud of you, high fives.
Now, let's move on to some bigger and better things.
We're gonna talk about section three
which is logical operators.
And for those of you
who don't know what logical operators are,
they're basically founded in the simple concept
of an if-then statement.
So if I'm hungry, then I'm going to go make a sandwich.
That's a logical operator.
So, we're gonna start with the anatomy of the IF statement,
what the formula syntax looks like.
We're gonna talk about nested logical operators,
so that you can test multiple logical statements
in a single formula.
We'll talk AND and OR operators,
two forms of the NOT statement,
and then a handful of IS statements.
So, there are a whole slew of IS statements in Excel.
We're gonna talk about a number of them
that I find most useful.
And last but not least, two files for download.
We've got the PDF
and then we've got our Excel file that we'll be using
for hands-on demos, called Section 3 - Logical Operators.
So, go ahead and open that up.
Open up the PDF and let's jump in.