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
   39   40   41   42   43   44   45   46   47   48   49