Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 29

    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
                              1  Type this                                             strings using cell reference.
                             data.

                                 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

                       28   Premium Edition-VII

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