Page 35 - CG_v2.1_flipBooks_class_6
P. 35

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
   30   31   32   33   34   35   36   37   38   39   40