From the example given below, you will learn how toenter and copy formulas. In this example, you have to calculate the total price of each quantity and then the final total value of all quantities. To calculate the total price of the pens, you enter the quantity in cell address B2 and price in cell address C2. Multiply these values and place the result in cell address D2. Repeat the procedure for the items Pencil and Pen Box. The total of all the three items will be placed in cell address D5.
Formula can also be entered by using the cell address. In the above example, the value is to be calculated by using the formula Quantity * Rate. To calculate the value of first item, pen, in the cell D2, type = B2 * C2 or +B2*C2 (Cell names can be indicated by small letters or capital letters). When typed, it will appear in cell D2.
Use the same procedure to calculate the cost for Pencil and Pencil Box and then add the values to get the final total.
No comments:
Post a Comment