Page 49 - TP_Plus_v4_Class6
P. 49
Functions Purpose Example
Input: =LEN(“Touch”)
Len(text) It returns the length of the text string.
Output: 5
Input: =UPPER(“Touch”)
Upper(text) It converts the text string into upper case.
Output: TOUCH
Input: =LOWER(”Touch”)
Lower(text) It converts the text string into lower case.
Output: touch
Let us use the Text functions by performing the following steps:
Type =CONCATENATE(A3,B3)
Type the given function to concatenate the
1 data in the Excel first name and last name and 2
worksheet. press Enter key.
When you press the Enter key, first name and last name appear after concatenation, ChiragSharma in
this case.
Logical Functions
Logical functions are used to test whether condition is true or false.
Functions Purpose Example
Percentage = 80
It checks whether the given condition is fulfilled or not, Input: =IF(Percentage >=
IF(condition, and returns value1 if the condition evaluates to true,
value1, value2) 50, “Passed”, “Failed”)
and returns value2 if the condition evaluates to false.
Output: Passed
Let us use the logical functions in Excel.
Perform the following steps to use the logical functions:
Type the given
1 data in the Excel
worksheet.
2 Type =MAX(B3:F3) function in the cell G3 to find
the maximum marks and press Enter key.
#Charts, Formulas and Functions in Excel 47

