Page 53 - modular4.0
P. 53
Chapter Profile
Calculating average of marks
Logical Functions
Function Purpose Example
It checks whether the given condition met, Percentage = 80
IF(condition, and returns value1 if the condition evaluates Input: =IF(Percentage >= 50,
value1, value2) to true, and returns value2 if the condition “Passed”, “Failed”)
evaluates to false. Output: Passed
Date and Time Functions
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2024
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2024
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
It returns the current system date and Input: = NOW()
NOW()
time. Output: 04-12-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
Let us use the date functions in Excel 2019 by performing the following steps:
1 Type =TODAY()
in the cell and press
Enter key.
When you press the Enter key, the current date appears in the cell.
2 Type =MONTH(TODAY())
function in the cell and press
the Enter key.
Formulas and Functions 51

