Page 35 - ThinkGPT_V2.1_C6_Flipbook
P. 35
When you press the Enter key, the first name appears in uppercase.
4 Type =LOWER(A3) function to convert the
first name into lowercase and press the Enter key.
When you press the Enter key, the first name appears in lowercase.
Logical Functions
Function Purpose Example
It checks whether the given condition is met, Percentage = 80
IF(condition, and returns value1 if the condition evaluates to Input: =IF(Percentage >= 50,
value1, value2) true, and value2 if the condition evaluates to “Passed”, “Failed”)
false. Output: Passed
Let us use the logical function in Excel.
Perform the following steps to use the logical function:
1 Type the given
data in the Excel
worksheet.
2 Type = IF(J3<33,"Fail","Pass") function in the cell K3 to find
the result and press Enter key.
Date and Time Functions
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 14/07/2024
Input: =MONTH(TODAY())
MONTH(date) It returns the month of the given date.
Output: 7
Formulas and Functions in Excel 33

