Page 34 - Digicode_AI_class_6
P. 34

Logical Functions


             Functions        Purpose                                            Example

                                                                                 Input: =MAX(4,16,12,9)
             MAX(range)       It returns the largest value in the given range.
                                                                                 Output: 16
                                                                                 Input: =MIN(4,16,12,9)
             MIN(range)       It returns the smallest value in the given range.
                                                                                 Output: 4

             AVERAGE          It returns the average of the given numbers in a  Input: =AVERAGE(12,3,6)
             (range)          range.                                             Output: 7

                              It checks whether the given condition is met,      Percentage = 80
             IF(condition,    and returns value1 if the condition evaluates to  Input: =IF(Percentage >= 50,
             value1, value2) true, and value2 if the condition evaluates to      “Passed”, “Failed”)
                              false.                                             Output: Passed


            Let us use the logical functions in Excel.
            To use the logical functions, follow the given steps:






               1   Type  the  following
              data  in  the  Excel
              worksheet.








                                                                        2  Type =MAX(B3:F3) function to find the
                                                                       maximum marks and press the Enter key.



            When you press the Enter key, the maximum marks appear in 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.





                 32    DigiCode AI-VI
   29   30   31   32   33   34   35   36   37   38   39