Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - logicode 2609 C6
P. 24

    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 with their examples are given below:

                            Function                              Purpose                              Example

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

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

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

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

                       22   Premium Edition-VI

| 19 20 21 22 23 24 25 26 27 28 29 |