Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 60 - 2611_SmartGPT Pro V(5.0) C-5
P. 60

    Perform the following steps to use the IF function:

                         1  Type the given
                        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
                                           It returns the current system date and          Input: = NOW()
                       NOW()
                                           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.

                       58   Computer Science (V5.0)-V

| 55 56 57 58 59 60 61 62 63 64 65 |