Page 29 - TP_iPlus_V2.1_Class8
P. 29

Functions                          Purpose                               Example

                                                                                      Input: =YEAR(TODAY())
                 YEAR(date)             It returns the current year.
                                                                                      Output: 2024
                                                                                      Input: =DAY(TODAY())
                 DAY(date)              It returns the current day.
                                                                                      Output: 23

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

                 To use the date functions, follow the given steps:


                                                                           1  Type =TODAY()
                                                                           function in the cell A1
                                                                           and press the Enter key.











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



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







                 When you press the Enter key, the month of the selected 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.
                 Logical Functions


                     Functions                        Purpose                                 Example

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



                                                                                                                  27
                                                                              Spreadsheet—Functions and Charts
   24   25   26   27   28   29   30   31   32   33   34