Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2617_JSSPS_C-6
P. 22

    Text Functions

                  Text functions are used to work on the characters entered as text.

                          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 characters    Input: =LEFT(“Touch”,3)
                   Left(text, num_chars)
                                             from the left side of the text string.           Output: Tou

                                             It returns the specified number of characters    Input: =RIGHT(“Touch”,3)
                   Right(text, num_chars)
                                             from the right side of the text 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:

                                                                                         Type =CONCATENATE(A3,B3)
                        Type the given                                                   function  to concatenate the
                    1   data in the Excel                                                first name and last name and   2
                        worksheet.                                                       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
                                                                                               Percentage = 80
                                      It checks whether the given condition is fulfilled or not
                   IF(condition,      and  returns  value1  if  the  condition evaluates to  true   Input: =IF(Percentage >=
                   value1, value2)                                                             50, “Passed”, “Failed”)
                                      and value2 if the condition evaluates to false.
                                                                                               Output: Passed

                     20     Premium Edition-VI

| 17 18 19 20 21 22 23 24 25 26 27 |