Page 43 - ModularV1.1 _c6_flipbook
P. 43
Functions Purpose Example
It returns the count of the number Input: =COUNT(4,8,12)
COUNT(range)
of values in the selected range. Output: 3
ROUND(number, It returns a number after rounding Input: =ROUND(35.666,2)
number_of_digits) to the specified digits. Output: 35.67
It returns the absolute value of a Input: =ABS(-25)
ABS(number)
given number. Output: 25
Let us use the mathematical functions in MS Excel.
Perform the following steps to use the
mathematical functions:
Step 1 Type the following data in the MS Excel
worksheet.
Step 2 To calculate the price of Pencils, type the
=PRODUCT(B3:C3) function in the cell
D3.
Using PRODUCT function
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.
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.
Step 6 Calculate the Tax by using the Using SUM function
=(D6*7)/100 formula.
Step 7 Calculate the Total by using the
=SUM(D6:D7) function. Final output
appears as shown:
Text Functions
Displaying Total
Functions Purpose Example
Input: =CONCATENATE(“Touch”,
CONCATENATE(text1, It joins together two or more
“pad”)
text2) different text strings.
Output: Touchpad
Formulas and Functions 41

