Page 25 - iPlus_Ver_2.0_class_8
P. 25
Functions Purpose Example
It rounds the number to an integer Input: =INT(14.25)
INT(number)
value. Output: 14
It returns the result of a number Input: =POWER(5,3)
POWER(number, power)
raised to some power. Output: 125
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 Excel.
To use the mathematical functions, follow the given steps:
1 Type the
following data
in the Excel
worksheet.
2 To calculate the price of Pencils, type
the =PRODUCT(B3:C3) function and
press the Enter key.
Info Byte
In functions, we can also use the cell address in place of the values.
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.
23
Spreadsheet—Functions and Charts

