Page 26 - TP_iPlus_V2.1_Class8
P. 26
4 To calculate
the tax, type the
=PRODUCT(D6,C7)
function in cell D7
and press the Enter
key.
5 To calculate the total bill, type the =SUM(D6:D7) function in cell D8
and press the Enter key.
Text Functions
Functions Purpose Example
Input: =CONCATENATE(“Touch”, “pad”)
CONCATENATE(text1, It joins together two or more
text2) different text strings. Output: Touchpad
It returns the specified number Input: =LEFT(“Touch”,3)
LEFT(text, num_chars) of characters from the left side of Output: Tou
the text string.
It returns the specified number of Input: =RIGHT(“Touch”,3)
RIGHT(text, num_chars) characters from the right side of Output: uch
the text string.
It returns the length of the text Input: =LEN(“Touch”)
LEN(text)
string. Output: 5
It converts the text string into Input: =UPPER(“Touch”)
UPPER(text)
uppercase. Output: TOUCH
It converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lowercase. Output: touch
To use the text functions, follow the given steps:
1 Type the
following
data in
the Excel 2 Type =CONCATENATE(A3,B3)
function to concatenate the First
worksheet.
Name and Last Name and press
the Enter key.
24
iPlus (Ver. 2.1)-VIII

