Page 87 - PlusGPT_V2.1_C7_Flipbook
P. 87

Mathematical Functions

                      Functions                            Purpose                                 Example

                                                                                          Input: =SUM(4,8,12,16)
                  SUM(range)           It adds the values in a range of cells.
                                                                                          Output: 40
                                                                                          Input: =PRODUCT(4,2,8)
                  PRODUCT(range)       It multiplies the values in a range of cells.
                                                                                          Output: 64
                  ROUND(number,        It returns a number after rounding to the specified  Input: =ROUND(35.666,2)
                  number_of_digits)    digits.                                            Output: 35.67




                                                            Tech Fact
                                 In functions, we can also use the cell address in place of the values.




                 Let us use the mathematical functions in Excel 2016.
                 Perform the following steps to use the mathematical functions:

                 Step 1:   Type  the given data  in the  Excel   2016
                          worksheet.

                 Step 2:   To calculate  the price  of  Pencils, type  the
                          =PRODUCT(B3:C3) function in the cell D3.
                 Step 3:  Press the Enter key from the keyboard.
                 When you  press the  Enter key,  price  of the  pencils

                 appears in the cell D3. Using the AutoFill feature, we can
                 calculate the prices of the Geometry Boxes and Pens.                 Using PRODUCT function



                                                              Step 4:   To calculate the subtotal, type the =SUM(D3:D5)

                                                                       in the cell D6.
                                                              Step 5:   Press the Enter key from the keyboard.

                                                              When you press the Enter key, subtotal appears in the
                                                              cell D6.

                              Using SUM function

                 Step 6:   Calculate  the  Tax by using the  =(D6*7)/100
                          formula in cell D7.

                 Step 7:   Calculate the Total by using the =SUM(D6:D7)
                          function in cell D8. Final output appears as
                          shown:
                                                                                          Displaying Total


                                                                                           Formulas and Functions  85
   82   83   84   85   86   87   88   89   90   91   92