Page 48 - Plus_V2.2_C6_Flipbook
P. 48

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

                  Step 1:  Type the following data in the Excel worksheet.
                  Step 2:  Calculate the percentage using the average function.
                  Step 3:   Type =IF($H3>=33, "Passed", "Failed") function in cell I3 to check whether the student passed or
                          failed.

                  Step 4:  Press the Enter key on the keyboard.

















                                                           Using Logical function

                  When you press the Enter key, the maximum marks appear in the cell G3. Using the AutoFill feature,
                  find the maximum marks of each student. Similarly, we can find the minimum marks by using the
                  MIN() function.

                  Date and Time Functions

                        Functions                           Purpose                                Example
                                                                                          Input: =TODAY()
                   TODAY()              It returns the current date.
                                                                                          Output: 7/23/2019
                                                                                          Input: =MONTH(TODAY())
                   MONTH(TODAY())       It returns the current month.
                                                                                          Output: 7
                                                                                          Input: =YEAR(TODAY())
                   YEAR(TODAY())        It returns the current year.
                                                                                          Output: 2019
                                                                                          Input: =DAY(TODAY())
                   DAY(TODAY())         It returns the current day.
                                                                                          Output: 23
                                                                                          Input: = NOW()
                   NOW()                It returns the current system date and time.
                                                                                          Output: 21-05-2020 11:24
                                                                                          Input: = HOUR(NOW())
                   HOUR(time)           It returns the hour from a given time.
                                                                                          Output: 11
                                                                                          Input: MINUTE(NOW())
                   MINUTE(time)         It returns the minutes from a given time.
                                                                                          Output: 24


                  Let  us use  the date  functions  in Excel by  performing the
                  following steps:
                  Step 1:  Type =TODAY() in the cell.


                  46    Premium Edition-VI
   43   44   45   46   47   48   49   50   51   52   53