Page 27 - Trackpad_V1_Book 6_Flipbook
P. 27
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
It returns the square root of the given Input: =SQRT(81)
SQRT(number)
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
It returns the count of the number of values Input: =COUNT(4,8,12)
COUNT(range)
in the selected range. Output: 3
ROUND(number, It returns a number after rounding to the Input: =ROUND(35.666,2)
number of digits) specified digits. Output: 35.67
It returns the absolute value of a given Input: =ABS(–25)
ABS(number)
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 Insert
Function option.
1 Select an empty
cell to hold the sum
of the numbers.
4 Click on
OK button.
Formulas and Functions in Excel 2010 25

