Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 53 - 2620_Birla Open Mind C-6
P. 53

    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  51

| 48 49 50 51 52 53 54 55 56 57 58 |