Page 58 - TP_Prime_v2.2_Class_6
P. 58

Logical Functions

                        Function                        Purpose                               Example

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

                                          value1 if the condition evaluates  “Passed”, “Failed”)
                                          to true, and returns value2 if the
                                                                                 Output: Passed
           Prime (Ver. 2.2)-VI  Statistical Functions
                                          condition evaluates to false.







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

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

                                         It  returns the count of the  Input: =COUNT(4,8,12)
                   COUNT(range)          number of values in the selected
                                         range.                                  Output: 3

                  Let us use the Statistical functions in Excel.

                  Perform the following steps to use the Statistical functions:

                  Step 1:  Type the following data in the 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.



















                                                           Using MAX Function
   53   54   55   56   57   58   59   60   61   62   63