Page 26 - iprime_V2.2_class8
P. 26
Step 4 To calculate the subtotal, type =SUM(D3:D5) in the cell D6.
Step 5 Press the Enter key.
Using SUM Function
When you press the Enter key, the subtotal appears in cell D6.
Step 6 Calculate Tax by using =(D6*7)/100 formula in cell D7.
Step 7 Calculate Total by using =SUM(D6:D7) function in cell D8. The final output appears as
shown:
Displaying Total
Text Functions
Functions Purpose Example
Input: =CONCATENATE(“Touch”,
Joins together two or more
CONCATENATE(text1, text2) “pad”)
different text strings
Output: Touchpad
Returns the specified number Input: =LEFT(“Touch”,3)
LEFT(text, num_chars) of characters from the left
Output: Tou
side of the text string
Returns the specified number Input: =RIGHT(“Touch”,3)
RIGHT(text, num_chars) of characters from the right
Output: uch
side of the text string
24 iPRIME (Ver. 2.2)–VIII

