Page 30 - TP-Play_V-2.0_Book-6
P. 30

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         Percentage = 80
             IF(condition,        met,  and  returns  value1  if the  condition  Input: =IF(Percentage  >=
             value1, value2)      evaluates to true, and returns value2 if the  50, “Passed”, “Failed”)
                                  condition evaluates to false.                  Output: Passed


            Let us use the logical functions in Excel 2016.
            Perform the given steps to use the logical functions:

            Step 1  Type the given data in the Excel 2016 worksheet.
            Step 2   Type  =MAX(C3:G3)  function
                    in the cell  H3  to  find  the
                    maximum marks.

            Step 3   Press  the  Enter  key  from  the
                    keyboard.                                              Using MAX function
            When you press the Enter key, the maximum marks appear in the cell H3. 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(C3:G3) function in the cell J3 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 J3. Using the AutoFill
            feature, we can calculate the average of marks of each student.











                                                  Calculating average of marks

             30       Play (Ver. 2.0)-VI
   25   26   27   28   29   30   31   32   33   34   35