Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 16 - 2612 Digimind C6
P. 16

    Function                           Purpose                               Example

                        LEFT(text,            It returns the specified number of characters   Input: =LEFT("Track",3)
                        num_chars)            from the start of the text string.             Output: Tra

                        RIGHT(text,           It returns the specified number of characters   Input: =RIGHT("Track",3)
                        num_chars)            from the end of the text string.               Output: ack

                                                                                             Input: =LEN("Track")
                        LEN(text)             It returns the length of the text string.
                                                                                             Output: 5
                                                                                             Input: =UPPER("Track")
                        UPPER(text)           It converts the text string into uppercase.
                                                                                             Output: TRACK

                                                                                             Input: =LOWER("Track")
                        LOWER(text)           It converts the text string into lowercase.
                                                                                             Output: track

                      For example, CONCATENATE () function:

                                                                                         2  Type =CONCATENATE(A1,B1)
                                                                                         function to concatenate two
                                                                                         strings using cell reference.
                            1  Type this data.

                      STATISTICAL AND LOGICAL FUNCTIONS
                      Some statistical and logical functions 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

                       14   Premium Edition-VI

| 11 12 13 14 15 16 17 18 19 20 21 |