Page 49 - TP_Plus_v4_Class6
P. 49

Functions                             Purpose                                 Example
                                                                                            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 lower case.
                                                                                            Output: touch

                Let us use the Text functions by performing the following 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, first name and last name appear after concatenation, ChiragSharma in
                this case.

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


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

                Let us use the logical functions in Excel.

                Perform the following steps to use the logical functions:






                         Type  the  given
                     1   data in the  Excel
                         worksheet.









                                                 2   Type =MAX(B3:F3) function in the cell G3 to find
                                                     the maximum marks and press Enter key.





                                                                               #Charts, Formulas and Functions in Excel  47
   44   45   46   47   48   49   50   51   52   53   54