Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - logicode 2609 C6
P. 25

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

                     For example, MAX () function:

                                                                                            2  Type =MAX(B3:F3)
                                                                                            function in the cell G3.

                                   1  Type this data.

                     Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the
                     minimum marks by using the MIN() function.

                     DATE AND TIME FUNCTIONS
                     Some date and time functions with their examples are given below:

                            Function                           Purpose                               Example

                                                                                            Input: =TODAY()
                      TODAY()                It returns the current date.
                                                                                            Output: 23-07-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
                                                                                            Input: =NOW()
                      NOW()                  It returns the current system date and time.
                                                                                            Output: 23-07-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

                                                                                     Formulas and Functions in Excel 2021  23

| 20 21 22 23 24 25 26 27 28 29 30 |