Page 28 - KEC Khaitan C6 Flipbook
P. 28
Let’s discuss the categories of function.
MATHEMATICAL FUNCTIONS
Some mathematical functions with their examples are given below:
Function Purpose Example
Input: =SUM(4,8,12,16)
SUM(range) It returns the sum of a range.
Output: 40
Input: =PRODUCT(4,2,8)
PRODUCT(range) It multiplies the values in a range of cells.
Output: 64
MOD It returns the remainder after a number is Input: =MOD(8,5)
(number, divisor) divided by the divisor. Output: 3
Input: =SQRT(81)
SQRT(number) It returns the square root of the given number.
Output: 9
Input: =INT(14.25)
INT(number) It rounds the number to an integer value.
Output: 14
POWER It returns the result of a number raised to Input: =POWER(5,3)
(number, power) some power. Output: 125
ROUND(number, It returns a number after rounding to the Input: =ROUND(35.666,2)
number of digits) specified digits. Output: 35.67
Input: =ABS(–25)
ABS(number) It returns the absolute value of a given number.
Output: 25
Let us understand this by taking an example of the SUM( ) function. Perform the following steps:
2 Click on Formulas tab.
3 Click on the
Insert Function
command.
1 Select an 4 Select SUM
empty cell to in the Select a
hold the sum of Function List.
the numbers.
5 Click on the
OK button.
26 Premium Edition-VI

