Page 47 - Trackpad_V4.0_c6_Flpbook
P. 47
Text Functions
Text functions are used to work on the characters entered as text.
Functions Purpose Example
Input: =CONCATENATE
Concatenate It joins together two or more different text (“Touch”, “pad”)
(text1, text2) strings.
Output: Touchpad
It returns the specified number of characters Input: =LEFT(“Touch”,3)
Left(text, num_chars)
from the left side of the text string. Output: Tou
It returns the specified number of characters Input: =RIGHT(“Touch”,3)
Right(text, num_chars)
from the right side of the text string. Output: uch
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 lowercase.
Output: touch
Let’s use the Text functions by following these 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, the first name and last name appear after the concatenation.
Logical Functions
Logical functions are used to test whether a condition is true or false.
Functions Purpose Example
Percentage = 80
It checks whether the given condition is fulfilled or not
IF(condition, and returns value1 if the condition evaluates to true Input: =IF(Percentage >=
value1, value2) 50, “Passed”, “Failed”)
and value2 if the condition evaluates to false.
Output: Passed
Charts, Formulas & Functions in Excel 45

