Hello, everyone, in this lecture, we will cover important logical functions.
We begin by discussing the logical based on single argument that is in one particular condition is true
or false.
Single argument can be implemented very easily by just typing is equal to select Essel and apply the
condition.
In this case, we want to identify if any student has scored a hundred in maths or not.
Today is equal to select, this is equal to extend as far as the sales.
The outcome is true for only one student, the student who was caught under immense.
When we have two or more arguments, two situations arise, either we want to check that all arguments
are true or not, what we want to take if any one or more of the arguments us is true or not, if all
arguments are to be true views and statements.
For example, if we want to identify students who have distinction that if they have scored 75 in only
three subjects we will use is equal to an.
And then all the three conditions separated by commas.
Extended.
We can see that these wounds are more than 75 marks in all the three subjects.
If you want to check truthfulness of any one or more of the arguments we use, or, for example, if
you want to request to to a billion anyone or more of these subject we use is equal to or an entirely
reargument.
We extended we can see that only one of these children has failed because that student scored 30 in
English, which is less than 35.
Let's move on to the next formula, which is the formula.
This formula uses the outcome of the logical test that we discussed previously and gives predefined
output for true and false outcomes.
For example, if you want to assign grade to students, this is their math score.
The student with equal to or more than 75 marks in math has graded else has great B..
We do this by typing is equal to if the logical test.
Output, if true.
Outputted foot.
Extended for another four in total.
If we want to do multiple logical tests in sequential format, we can use narrative's method, it means
that within one if statement you use another statement, which will be called is the output of Fosdick.
It will be easier to understand this using an example here.
If we want to grade students as a if as more than equal to a different B if scores between 60 and 85
and see if Skouras less than 60 are first, if will check if it is more than 85 if Roe with Wade grade
a default.
I second biggest initiative will take if it is than 60 or not.
If it is less than 60, then grapeseed else could be.
We can further have more ifs if we want to have more checks, such as to introduce B, we can further
have another check of 40 monks.
Try to do that yourself.
You can also have an op ed in the statement if we want to check several conditions at the same time
in the privacy we used and and or which was giving a reward for this outcome.
Now, using if we can have particular output to these outcomes, if true, we want to output Basswood
distinction.
It's nothing to let's apply this formula.
Passed with distinction.
For hour, we will have if crude output will be filled.
Else we will have promoted to next class.
Two or the three conditions in less than 35 seconds, less than 30 minutes.
There's another debate.
If true, the.
It's promoted to next class.
Extended for a of intelligent.
The last student fame as well, all the other four students have been promoted to next class.
Next, we move on to county function, although this is part of statistical formulas and the formulas
menu, but we will discuss it with the logical if formula only due to its similarity with a function.
Count of returns, the count of cells which satisfy the given criteria, if we want to identify a number
of students who have scored grade A, B or C in a very subdued retape is equal to count of.
The intellect derange.
Former means director Didier.
And.
Extended for other groups also.
So when match great matches with a gun counted as one, so we have to restore integrity to it greatly
and no one would see similar operation can be done on the subject.
Remember to put a dollar sign appropriately before extending the formula.
You can refer a previous lecture to see how to put dollar signs in the formulas before extending them.
If we want to have multiple takes while counting count, if it can be used to implement, Count IPPs
retape is equal to count first range, first criteria, then secondary in second criteria and so on.
So to get the count of students with distinction, we use contests as follows.
If you call two counties and five to nine criteria, then it's in range selected area.
And he told Range Radio.
And the advantage of using condoms is just by changing the value in this cell resistant bacteria cell
of 75, we can change the criteria of classification of distinction or not.
We can see that no student has scored more than 80 marks in all subject, however, context only gives
us the count.
It does not tell you which student is actually password distinction.
Which we found out earlier using the Iftikar make.
Next up is summer formula.
This is also not part of logical formulas, but it is under mathematical formulas.
But let's cover this also in a different context.
Some of it is similar to the only difference that it will add the cells which satisfy the criteria instead
of just counting them.
For example, if you want to find some of the marks of student in maths, we have not.
Will we start by typing is equal to of.
First, select the criteria range, which we'll call column.
Then specify criteria, which is it falls.
Then specify the range, some range.
It is the math school of the student.
This is a three 349 as a result, which is some of math scores of students who were passed class.
That is the first four students.
Ninety nine plus 65 plus 85 plus hundred, which is three for me.
Similarly, you can find this for other subjects also to fill the table.
Like we discussed condoms, I would encourage you to explore some tips on your own.
That's all for this lecture.
In the next lecture, we will discuss the dating formulas.
Thanks.