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

