Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2617_JSSPS_C-6
P. 23

    Perform the following steps to use the IF function:

                             Type the given
                         1   data in the Excel
                             worksheet.

                                      2   Type =IF(B2>=45, "Pass", "Fail") function in the
                                          cell C2 to find the result and press the Enter key.

                     Here, the IF function evaluates whether each student’s score is greater than or equal to 45, and based
                     on that evaluation, the function will return either Pass or Fail as a result.
                     Date and Time Functions

                     Date and Time functions are used to work or system's date and time.

                          Functions                           Purpose                                   Example

                                                                                             Input: =TODAY()
                     Today()               It returns the current date.
                                                                                             Output: 8/3/2024
                                                                                             Input: =MONTH(TODAY())
                     Month(Today())        It returns the current month.
                                                                                             Output: 8

                                                                                             Input: =YEAR(TODAY())
                     Year(Today())         It returns the current year.
                                                                                             Output: 2024

                                           It returns the current day from the date          Input: =DAY(TODAY())
                     Day(Today())
                                           specified.                                        Output: 3
                                                                                             Input: = NOW()
                     NOW()                 It returns the current system date and time.
                                                                                             Output: 8/3/2024 10:47

                                                                                             Input: = HOUR(NOW())
                     HOUR(time)            It returns the hour from a given time.
                                                                                             Output: 10
                                                                                             Input: = MINUTE(NOW())
                     MINUTE(time)          It returns the minutes from a given time.
                                                                                             Output: 47

                     You can use the date functions in Excel. To do so, type =TODAY() in the cell and press the Enter key
                     from the keyboard.
                                                                                                    Date Function
                     When you press the Enter key, the current date appears in the cell.
                     We can also give the reference of a cell containing the date to the
                     MONTH() function. Similarly, we can use the YEAR() and DAY()
                     functions to get the year and day from a date respectively.

                                                                                                 Using TODAY function

                                                                                 Charts, Formulas & Functions in Excel  21

| 18 19 20 21 22 23 24 25 26 27 28 |