Page 45 - ModularV1.1 _c7_flipbook
P. 45

Logical Functions

                      Functions                          Purpose                                Example

                                       It returns the largest value in the given  Input: =MAX(4,16,12,9)
                  MAX(range)
                                       range.                                         Output: 16
                                       It returns  the  smallest  value in the  given  Input: =MIN(4,16,12,9)
                  MIN(range)
                                       range.                                         Output: 4
                                       It returns the average of the given numbers  Input: =AVERAGE(12,3,6)
                  AVERAGE(range)
                                       in a range.                                    Output: 7

                                       It checks whether  the given condition is      Percentage = 80
                  IF(condition,        met,  and  returns  value1  if the  condition  Input: =IF(Percentage >= 50,

                  value1, value2)      evaluates to true, and returns value2 if the  “Passed”, “Failed”)
                                       condition evaluates to false.                  Output: Passed

                 Let us use the logical functions in MS Excel.

                 Perform the following steps to use the logical functions:
                 Step 1  Type the following data in the MS Excel worksheet.

                 Step 2  Type =MAX(B3:F3) function in the cell G3 to find the maximum marks.
                 Step 3  Press the Enter key from the keyboard.
                 When you press the Enter key, the maximum marks appear in the cell G3. Using the AutoFill

                 feature, find the maximum marks of each student. Similarly, we can find the minimum marks by
                 using the MIN() function.
                 Step 4  Type =AVERAGE(B3:F3) function in the cell I3 to find the average of marks.

                 Step 5  Press the Enter key from the keyboard.








                                                        Using AVERAGE function

                 When you press the  Enter key, the
                 average  of marks appears  in the cell
                 I3. Using the  AutoFill feature,  we can
                 calculate the average of marks of each
                                                                                Using MAX function
                 student.










                                                      Calculating average of marks



                                                                                          Formulas and Functions  43
   40   41   42   43   44   45   46   47   48   49   50