1
00:00:08,070 --> 00:00:12,190
Hello, everyone, in this lecture, we will cover important logical functions.

2
00:00:12,960 --> 00:00:18,780
We begin by discussing the logical based on single argument that is in one particular condition is true

3
00:00:18,780 --> 00:00:19,290
or false.

4
00:00:19,890 --> 00:00:25,980
Single argument can be implemented very easily by just typing is equal to select Essel and apply the

5
00:00:25,980 --> 00:00:26,440
condition.

6
00:00:27,150 --> 00:00:32,250
In this case, we want to identify if any student has scored a hundred in maths or not.

7
00:00:33,300 --> 00:00:42,120
Today is equal to select, this is equal to extend as far as the sales.

8
00:00:43,460 --> 00:00:48,730
The outcome is true for only one student, the student who was caught under immense.

9
00:00:50,220 --> 00:00:56,000
When we have two or more arguments, two situations arise, either we want to check that all arguments

10
00:00:56,000 --> 00:01:02,360
are true or not, what we want to take if any one or more of the arguments us is true or not, if all

11
00:01:02,360 --> 00:01:05,730
arguments are to be true views and statements.

12
00:01:05,790 --> 00:01:12,890
For example, if we want to identify students who have distinction that if they have scored 75 in only

13
00:01:12,890 --> 00:01:16,700
three subjects we will use is equal to an.

14
00:01:19,510 --> 00:01:22,240
And then all the three conditions separated by commas.

15
00:01:37,290 --> 00:01:38,040
Extended.

16
00:01:40,150 --> 00:01:44,530
We can see that these wounds are more than 75 marks in all the three subjects.

17
00:01:45,750 --> 00:01:50,960
If you want to check truthfulness of any one or more of the arguments we use, or, for example, if

18
00:01:50,970 --> 00:02:00,000
you want to request to to a billion anyone or more of these subject we use is equal to or an entirely

19
00:02:00,330 --> 00:02:01,080
reargument.

20
00:02:23,940 --> 00:02:32,040
We extended we can see that only one of these children has failed because that student scored 30 in

21
00:02:32,040 --> 00:02:33,450
English, which is less than 35.

22
00:02:36,000 --> 00:02:38,880
Let's move on to the next formula, which is the formula.

23
00:02:39,810 --> 00:02:45,750
This formula uses the outcome of the logical test that we discussed previously and gives predefined

24
00:02:45,750 --> 00:02:48,060
output for true and false outcomes.

25
00:02:48,840 --> 00:02:54,300
For example, if you want to assign grade to students, this is their math score.

26
00:02:54,570 --> 00:03:01,590
The student with equal to or more than 75 marks in math has graded else has great B..

27
00:03:02,670 --> 00:03:07,560
We do this by typing is equal to if the logical test.

28
00:03:16,050 --> 00:03:17,160
Output, if true.

29
00:03:20,870 --> 00:03:21,980
Outputted foot.

30
00:03:25,650 --> 00:03:27,300
Extended for another four in total.

31
00:03:31,860 --> 00:03:38,850
If we want to do multiple logical tests in sequential format, we can use narrative's method, it means

32
00:03:38,850 --> 00:03:44,820
that within one if statement you use another statement, which will be called is the output of Fosdick.

33
00:03:45,510 --> 00:03:48,910
It will be easier to understand this using an example here.

34
00:03:48,920 --> 00:03:56,970
If we want to grade students as a if as more than equal to a different B if scores between 60 and 85

35
00:03:57,330 --> 00:04:06,870
and see if Skouras less than 60 are first, if will check if it is more than 85 if Roe with Wade grade

36
00:04:07,420 --> 00:04:10,260
a default.

37
00:04:14,540 --> 00:04:19,310
I second biggest initiative will take if it is than 60 or not.

38
00:04:27,270 --> 00:04:30,870
If it is less than 60, then grapeseed else could be.

39
00:04:40,420 --> 00:04:46,480
We can further have more ifs if we want to have more checks, such as to introduce B, we can further

40
00:04:46,480 --> 00:04:48,340
have another check of 40 monks.

41
00:04:49,000 --> 00:04:50,140
Try to do that yourself.

42
00:04:51,820 --> 00:04:57,730
You can also have an op ed in the statement if we want to check several conditions at the same time

43
00:04:58,330 --> 00:05:03,650
in the privacy we used and and or which was giving a reward for this outcome.

44
00:05:04,060 --> 00:05:10,750
Now, using if we can have particular output to these outcomes, if true, we want to output Basswood

45
00:05:10,750 --> 00:05:11,310
distinction.

46
00:05:11,650 --> 00:05:14,350
It's nothing to let's apply this formula.

47
00:05:34,050 --> 00:05:35,300
Passed with distinction.

48
00:05:48,340 --> 00:05:53,590
For hour, we will have if crude output will be filled.

49
00:05:54,370 --> 00:05:57,820
Else we will have promoted to next class.

50
00:06:02,330 --> 00:06:14,150
Two or the three conditions in less than 35 seconds, less than 30 minutes.

51
00:06:14,300 --> 00:06:15,170
There's another debate.

52
00:06:18,660 --> 00:06:21,180
If true, the.

53
00:06:39,460 --> 00:06:41,110
It's promoted to next class.

54
00:06:43,530 --> 00:06:45,150
Extended for a of intelligent.

55
00:06:47,370 --> 00:06:53,430
The last student fame as well, all the other four students have been promoted to next class.

56
00:06:54,820 --> 00:07:01,510
Next, we move on to county function, although this is part of statistical formulas and the formulas

57
00:07:01,510 --> 00:07:07,300
menu, but we will discuss it with the logical if formula only due to its similarity with a function.

58
00:07:08,430 --> 00:07:16,170
Count of returns, the count of cells which satisfy the given criteria, if we want to identify a number

59
00:07:16,170 --> 00:07:22,800
of students who have scored grade A, B or C in a very subdued retape is equal to count of.

60
00:07:27,090 --> 00:07:28,330
The intellect derange.

61
00:07:32,060 --> 00:07:35,550
Former means director Didier.

62
00:07:39,450 --> 00:07:39,760
And.

63
00:07:43,050 --> 00:07:45,060
Extended for other groups also.

64
00:07:53,560 --> 00:08:01,710
So when match great matches with a gun counted as one, so we have to restore integrity to it greatly

65
00:08:02,470 --> 00:08:07,120
and no one would see similar operation can be done on the subject.

66
00:08:08,170 --> 00:08:11,920
Remember to put a dollar sign appropriately before extending the formula.

67
00:08:13,180 --> 00:08:19,150
You can refer a previous lecture to see how to put dollar signs in the formulas before extending them.

68
00:08:35,050 --> 00:08:42,400
If we want to have multiple takes while counting count, if it can be used to implement, Count IPPs

69
00:08:42,400 --> 00:08:50,100
retape is equal to count first range, first criteria, then secondary in second criteria and so on.

70
00:08:50,620 --> 00:08:56,170
So to get the count of students with distinction, we use contests as follows.

71
00:08:57,220 --> 00:09:06,770
If you call two counties and five to nine criteria, then it's in range selected area.

72
00:09:07,890 --> 00:09:10,620
And he told Range Radio.

73
00:09:13,620 --> 00:09:22,650
And the advantage of using condoms is just by changing the value in this cell resistant bacteria cell

74
00:09:22,650 --> 00:09:27,690
of 75, we can change the criteria of classification of distinction or not.

75
00:09:31,610 --> 00:09:40,820
We can see that no student has scored more than 80 marks in all subject, however, context only gives

76
00:09:40,820 --> 00:09:41,360
us the count.

77
00:09:41,520 --> 00:09:44,590
It does not tell you which student is actually password distinction.

78
00:09:45,720 --> 00:09:48,280
Which we found out earlier using the Iftikar make.

79
00:09:50,600 --> 00:09:52,160
Next up is summer formula.

80
00:09:52,940 --> 00:09:57,220
This is also not part of logical formulas, but it is under mathematical formulas.

81
00:09:57,650 --> 00:10:00,010
But let's cover this also in a different context.

82
00:10:01,100 --> 00:10:08,090
Some of it is similar to the only difference that it will add the cells which satisfy the criteria instead

83
00:10:08,090 --> 00:10:09,320
of just counting them.

84
00:10:10,370 --> 00:10:15,260
For example, if you want to find some of the marks of student in maths, we have not.

85
00:10:15,260 --> 00:10:18,800
Will we start by typing is equal to of.

86
00:10:22,300 --> 00:10:25,330
First, select the criteria range, which we'll call column.

87
00:10:27,210 --> 00:10:30,540
Then specify criteria, which is it falls.

88
00:10:34,390 --> 00:10:36,880
Then specify the range, some range.

89
00:10:37,120 --> 00:10:39,580
It is the math school of the student.

90
00:10:42,700 --> 00:10:49,300
This is a three 349 as a result, which is some of math scores of students who were passed class.

91
00:10:49,720 --> 00:10:51,840
That is the first four students.

92
00:10:52,450 --> 00:10:56,690
Ninety nine plus 65 plus 85 plus hundred, which is three for me.

93
00:10:57,550 --> 00:11:01,600
Similarly, you can find this for other subjects also to fill the table.

94
00:11:12,270 --> 00:11:16,810
Like we discussed condoms, I would encourage you to explore some tips on your own.

95
00:11:18,210 --> 00:11:19,380
That's all for this lecture.

96
00:11:19,590 --> 00:11:22,600
In the next lecture, we will discuss the dating formulas.

97
00:11:23,550 --> 00:11:24,000
Thanks.