Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 59 - 2611_SmartGPT Pro V(5.0) C-5
P. 59

    Functions                           Purpose                                Example

                                                                                             Input: =CONCATENATE
                     Concatenate           It joins together two or more different text      (“Touch”, “pad”)
                     (text1, text2)        strings.
                                                                                             Output: Touchpad

                                           It returns the specified number of                Input: =LEFT(“Touch”,3)
                     Left(text, num_       characters from the left side of the text         Output: Tou
                     chars)
                                           string.

                                           It returns the specified number of                Input:
                     Right(text, num_      characters from the right side of the text        =RIGHT(“Touch”,3)

                     chars)
                                           string.                                           Output: uch

                                                                                             Input: =LEN(“Touch”)
                     Len(text)             It returns the length of the text string.
                                                                                             Output: 5

                                                                                             Input: =UPPER(“Touch”)
                     Upper(text)           It converts the text string into upper case.
                                                                                             Output: TOUCH
                                                                                             Input: =LOWER(”Touch”)
                     Lower(text)           It converts the text string into lowercase.
                                                                                             Output: touch

                     Let’s use the Text functions by following these steps:

                                   1  Type the given
                                  data in the Excel
                                  worksheet.

                                                         2  Type =CONCATENATE(A3,B3)
                                                         function to concatenate the first name
                                                         and last name and press Enter key.

                     When you press the Enter key, the first name and last name appear after the concatenation.

                     Logical Functions

                     Logical functions are used to test whether a condition is true or false.

                        Functions                         Purpose                                  Example

                                        It checks whether the given condition is       Percentage = 80
                     IF(condition,      fulfilled or not and returns value1 if the     Input: =IF(Percentage >= 50,
                     value1, value2) condition evaluates to true and value2 if         “Passed”, “Failed”)
                                        the condition evaluates to false.              Output: Passed

                                                                                     Charts, Formulas & Functions in Excel  57

| 54 55 56 57 58 59 60 61 62 63 64 |