Page 34 - Computer Genius Class 06
P. 34

Logical Functions

                     Functions                           Purpose                                  Example

                                                                                       Input: =MAX(4,16,12,9)
                   MAX(range)        t returns the largest  alue in the gi en range.
                                                                                       Output: 16

                                                                                       Input: =MIN(4,16,12,9)
                   MIN(range)        t returns the smallest  alue in the gi en range.
                                                                                       Output: 4

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


                                    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”)
                                     alse.                                             Output: Passed


                   et us use the logical  unctions in   cel.
                  To use the logical functions, follow the given steps:






                    1   Type  the  following
                    data  in the  Excel
                     or sheet.







                                                                              2  Type =MAX(B3:F3) function to find the
                                                                             ma imum mar s and press the Enter  ey.


                  When you press the Enter  ey  the ma imum mar s appear in cell G3.  sing the AutoFill feature,
                  find the ma imum mar s o  each student.  imilarly   e can find the minimum mar s  y using the
                  MIN()  unction.






                       32    Computer Genius-VI
   29   30   31   32   33   34   35   36   37   38   39