Page 47 - Trackpad_V4.0_c6_Flpbook
P. 47

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







                                                                             Charts, Formulas & Functions in Excel  45
   42   43   44   45   46   47   48   49   50   51   52