Page 30 - iprime_V2.2_class8
P. 30

Using TODAY Function

                          When you press the Enter key, the current date appears in the cell.
                  Step 3  Type =MONTH(TODAY()) in the cell and press the Enter key.














                                                          Using MONTH Function
                  The current month will appear. You can also give 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 is  Percentage = 80
                   IF(condition,       met, and returns value1 if the condition  Input: =IF(Percentage >= 50,
                   value1, value2)     evaluates to  TRUE, and value2 if the  “Passed”, “Failed”)
                                       condition evaluates to FALSE.           Output: Passed
                                                                               Age = 18
                                       This  function returns  TRUE if  Score = 85
                   AND(condition1,
                                       all specified conditions are  true;  Input: =AND(Age >= 18,
                   condition2, ...)
                                       otherwise, it returns FALSE.            Score >= 60)
                                                                               Output: TRUE
                                                                               Age = 16
                                       This  function returns  TRUE if at
                   OR(condition1,                                              Score = 85
                                       least one of the specified conditions
                   condition2, ...)                                            Input: =OR(Age >= 18, Score >= 60)
                                       is true; otherwise, it returns FALSE.
                                                                               Output: TRUE


                  28     iPRIME (Ver. 2.2)–VIII
   25   26   27   28   29   30   31   32   33   34   35