Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - 2632_CodeMind
P. 32

    Let us use the mathematical functions in Excel. To use the mathematical functions, follow the given steps:

                                                                                                 2   To  calculate  the
                                                                                                price  of  Pencils, type
                        1  Type the
                                                                                                the =PRODUCT(B3:C3)
                        following data
                                                                                                function  and  press  the
                        in  the  Excel
                                                                                                Enter key.
                        worksheet.

                     When you press the Enter key, the price of the pencils appears in the cell D3. Using the AutoFill
                     feature, we can calculate the prices of the Geometry Boxes and Pens.

                                                       3  To calculate the subtotal, type the =SUM(D3:D5)
                                                      function and press the Enter key.

                                                                                                4  Calculate the Tax
                                                                                                by using the =D6*C7
                                                                                                formula.

                                   5  Calculate the Total by using the =SUM(D6:D7) function.

                                                                                  Formulas and Functions in Excel  31

| 27 28 29 30 31 32 33 34 35 36 37 |