Page 32 - CG_v2.1_flipBooks_class_6
P. 32
Mathematical Functions
Function 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 removes the decimal part of Input: =INT(14.25)
INT(number) the number and returns only the Output: 14
integer part.
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
In functions, we can also use the cell address in place of the values.
30 Computer Genius (V2.1)-VI

