Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - 2615_KEC
P. 28

    6  Type the arguments in the number fields which are
                        the range of cells to find the sum of their contents.

                                    7  Click on OK button.

                           Tick ( ) if you know this.
                               A formula starts with an (=) sign.

                               Functions are predefined formulas that perform a series of operations on a specified range of values.

                      STATISTICAL AND LOGICAL FUNCTIONS

                      Some statistical and logical with their examples are given below:

                             Function                           Purpose                               Example

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

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

                                                                                             Input: =AVERAGE(10, 12, 14)
                        AVERAGE(range)        It returns the average of a range of numbers.
                                                                                             Output: 12

                                              It returns the count of the number of values in  Input: =COUNT(4,8,12)
                        COUNT(range)
                                              the selected range.                            Output: 3
                                              It checks whether the given condition is met,  Percentage = 80
                        IF(condition, value1,   and returns value1 if the condition evaluates  Input: =IF(Percentage >= 50,
                        value2)               to  true,  and  returns value2  if the  condition  “Passed”, “Failed”)

                                              evaluates to false.                            Output: Passed

                       26   Premium Edition-VI

| 23 24 25 26 27 28 29 30 31 32 33 |