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

