Page 55 - TP_Prime_v2.2_Class_6
P. 55
Logical Functions: Evaluates conditions such as X > 5 and gives the result as true or false.
Statistical Functions: Calculates the maximum, minimum, average etc., of a set of numeric
data.
Date and Time Functions: Calculates the day, month and year in a date and the hour,
minute and second at a particular time.
Let us discuss these categories in detail. FORMULAS AND FUNCTIONS IN EXCEL
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
53
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 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
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
Soft Hint
In functions, we can also use the cell address in place of the values.
Let us use the mathematical functions in Excel.
Perform the following steps to use the mathematical functions:
Step 1: Type the data in the Excel worksheet as shown.

