Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2632_CodeMind
P. 34

    When you press the Enter key, the first name appears in uppercase.

                                                            4  Type =LOWER(A3) function  to  convert  the
                                                            first name into lowercase and press the Enter key.

                     When you press the Enter key, the first name appears in lowercase.

                     Logical Functions

                     Function          Purpose                                            Example

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

                     Let us use the logical function in Excel.
                     Perform the following steps to use the logical function:

                           1   Type  the  given
                          data  in  the  Excel
                          worksheet.

                                                        2  Type = IF(J3<33,"Fail","Pass") function in the cell K3 to find
                                                        the result and press Enter key.

                     Date and Time Functions

                     Function               Purpose                                       Example
                                                                                          Input: =TODAY()
                     TODAY()                It returns the current date.
                                                                                          Output: 14/07/2024
                                                                                          Input: =MONTH(TODAY())
                     MONTH(date)            It returns the month of the given date.
                                                                                          Output: 7

                                                                                  Formulas and Functions in Excel  33

| 29 30 31 32 33 34 35 36 37 38 39 |