Page 48 - Plus_V2.2_C6_Flipbook
P. 48
Let us use the logical functions in Excel.
Perform the following steps to use the logical functions:
Step 1: Type the following data in the Excel worksheet.
Step 2: Calculate the percentage using the average function.
Step 3: Type =IF($H3>=33, "Passed", "Failed") function in cell I3 to check whether the student passed or
failed.
Step 4: Press the Enter key on the keyboard.
Using Logical function
When you press the Enter key, the maximum marks appear in the cell G3. Using the AutoFill feature,
find the maximum marks of each student. Similarly, we can find the minimum marks by using the
MIN() function.
Date and Time Functions
Functions Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2019
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2019
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
Input: = NOW()
NOW() It returns the current system date and time.
Output: 21-05-2020 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 by performing the
following steps:
Step 1: Type =TODAY() in the cell.
46 Premium Edition-VI

