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

