Page 31 - Digicode_AI_class_6
P. 31
Mathematical Functions
Functions Purpose Example
Input: =SUM(4,8,12,16)
SUM(range) It returns the sum of a range.
Output: 40
It multiplies the values in a range Input: =PRODUCT(4,2,8)
PRODUCT(range)
of cells. Output: 64
It returns the remainder after a Input: =MOD(8,5)
MOD(number, divisor)
number is divided by the divisor. Output: 3
It returns the square root of the Input: =SQRT(81)
SQRT(number)
given number. Output: 9
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, number_ It returns a number after rounding Input: =ROUND(35.666,2)
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.
Formulas and Functions in Excel 29

