Page 44 - TP_Pluse_V2.2_Class_6
P. 44
Step 7: Calculate the Total by using the =SUM(D6:D7) function. Final output appears as shown:
Using PRODUCT function
Using SUM function Displaying Total
Text Functions
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
RIGHT(text, num_ It returns the specified number of characters Input: =RIGHT(“Touch”,3)
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 uppercase.
Output: TOUCH
Input: =LOWER(”Touch”)
LOWER(text) It converts the text string into lowercase.
Output: touch
42 Plus (Ver. 2.2)-VI

