Page 53 - modular4.0
P. 53

Chapter Profile







                                                      Calculating average of marks

                 Logical Functions

                       Function                          Purpose                                 Example

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

                 Date and Time Functions


                       Function                           Purpose                               Example

                                                                                     Input: =TODAY()
                 TODAY()                It returns the current date.
                                                                                     Output: 7/23/2024
                                                                                     Input: =MONTH(TODAY())
                 MONTH(TODAY())         It returns the current month.
                                                                                     Output: 7
                                                                                     Input: =YEAR(TODAY())
                 YEAR(TODAY())          It returns the current year.
                                                                                     Output: 2024
                                                                                     Input: =DAY(TODAY())
                 DAY(TODAY())           It returns the current day.
                                                                                     Output: 23
                                        It returns the current system date and       Input: = NOW()
                 NOW()
                                        time.                                        Output: 04-12-2024 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 2019 by performing the following steps:
                                            1  Type  =TODAY()
                                            in the cell and press
                                            Enter key.



                 When you press the Enter key, the current date appears in the cell.


                                        2  Type =MONTH(TODAY())
                                        function in the cell and press
                                        the Enter key.




                                                                                              Formulas and Functions  51
   48   49   50   51   52   53   54   55   56   57   58