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
   21   22   23   24   25   26   27   28   29   30   31