Page 31 - Computer Genius Class 06
P. 31
Mathematical Functions
Functions Purpose Example
Input: =SUM(4,8,12,16)
SUM(range) t returns the sum o a range.
Output: 40
It multiplies the values in a range Input: =PRODUCT(4,2,8)
PRODUCT(range)
o cells. Output: 64
It returns the remainder after a Input: =MOD(8,5)
MOD(number, divisor)
num er is di ided y the di isor. Output: 3
It returns the square root of the Input: =SQRT(81)
SQRT(number)
gi en num er. Output: 9
It rounds the number to an integer Input: T 1 .2
INT(number)
alue. Output: 14
It returns the result of a number Input: =POWER(5,3)
POWER(number, power)
raised to some po er. Output: 125
It returns the count of the number Input: =COUNT(4,8,12)
COUNT(range)
o alues in the selected range. Output: 3
ROUND(number, number_ It returns a number after rounding Input: . 2
of_digits) to the specified digits. Output: .
It returns the absolute value of a Input: 2
ABS(number)
gi en num er. Output: 25
et us use the mathematical unctions in cel. To use the mathematical unctions ollo the gi en steps
1 Type the following
data in the Excel
or sheet.
2 To calculate the price of Pencils, type the
=PRODUCT(B3:C3) function and press the Enter ey.
Formulas and Functions in Excel 29

