All right let's wrap up the logical operators section by talking about the Is statement.
It's nice and easy.
It's good simple one to finish on so Excel offers a number of different is formulas.
The point is that each checks whether very particular or certain condition is true.
So when you type in is function you're just going to return either true or false.
Those are the two possible values syntax wise.
It's about as easy as it possibly gets you just write the formula open a parenthesis and drop in your
value or reference and close it off and you're done.
So here's a sample list.
This is not comprehensive but it should give you a sense of some of the statements that are available
to you.
You can check whether your reference so or value is blank.
You can check if it's a number versus text.
If you're getting an error you can check if your value is even vs odd.
You can see if it's a logical operator or a formula and so on and so forth.
So let's jump into Excel and we're going to populate this last column column and called the missing
data and we want to identify and flag any cases where we have missing data in column G or temperature
column.
So I'm going to start with an error statement.
So is error open parenthesis arrow over to to close it up enter.
You see I get false there because I'm getting a valid data point in G-2 and then when I apply it down
you'll see it's flag that true here in row 12 because I'm getting an error in jete 12.
So that seems to work nicely.
But before I call it a day you'll note that I also have missing values in column G.
So it's not showing an error message but it's still a missing data point that I need to count for.
So if I wanted to just flag those what I could do is change this from is error to is blank again just
refer to g to apply that down.
I don't see that row 6 where I have a blank flags.
True but the error in row 12 no longer flags true because it's seeing an error which is not blank.
So what I need to do is combine these two and flag as true any case where Column G has a blank or an
error value.
So just keep the is blank that I already have.
I'm just going to start with or open up my parenthesis which gives my two logical values logical.
One is is blank logical two is going to be is error and just say no I can I can either click on G-2
here to make that reference I can also just type G-2 and it will read it as a reference as well.
That little tip and then close it off.
So now I have my or statement with two arguments.
So if it's either blank or it's in error this will flag as true otherwise false.
So let's see if that works seems to work properly.
I've got a blank and the true here I've got an error and a true here.
So it seems to be working properly.
And now one other thing I can do here is use my filter and say Show me the cases where I have missing
data.
So where this flagged as true and I can see what what dates did those missing data points fall on.
And then if I wanted to I could cut that data out or manipulate it in some other way.
But there you go those are just two examples of statements.
Again there are a number of others.
But with that that wraps up logical operators get excited because Section 4 we're going to talk about
statistical functions