Page 59 - 2611_SmartGPT Pro V(5.0) C-5

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 Input: =LEFT(“Touch”,3)
Left(text, num_ characters from the left side of the text Output: Tou
chars)
string.

It returns the specified number of Input:
Right(text, num_ characters from the right side of the text =RIGHT(“Touch”,3)

chars)
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:

1 Type the given
data in the Excel
worksheet.

2 Type =CONCATENATE(A3,B3)
function to concatenate the first name
and last name and 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

It checks whether the given condition is Percentage = 80
IF(condition, fulfilled or not and returns value1 if the Input: =IF(Percentage >= 50,
value1, value2) condition evaluates to true and value2 if “Passed”, “Failed”)
the condition evaluates to false. Output: Passed

Charts, Formulas & Functions in Excel 57