B) Mathematical Function:
1) Sum()
Sum function returns the
value equals all its arguments.
or
Adds all the numbers in a
range of cells.
Syntax:- =Sum(No1,No2,No3,......)
E.g. =Sum(20,40,60)
Press Enter
Output 120
2) Product ()
Multiple all the numbers
given as arguments and returns the Product.
Syntax:- =Product(No1,No2,No3,......)
E.g. =Product(15,6)
Press Enter
Output 90
3) Power()
Power function returns the
result of a number raised to power
Syntax:- =Power(Number,
Power)
E.g. =Power(2,6)
Press Enter
Output 64
4) Fact()
Fact function returns the
factorial of a number equal to 1*2*3*...........* Number.
Syntax:- =Fact(Number)
E.g. =Fact(5)
Press Enter
Output 120
5) Sqrt()
Sqrt function returns a
square root of a number.
Syntax:- =Sqrt(Number)
E.g. =Sqrt(144)
Press Enter
Output 12
6) Int()
Int function rounds a
number down to the nearest integer.
Syntax:- =Int(Number)
E.g. =Int(26.56)
Press Enter
Output 26
7) Mod()
Mod function returns the
remainder after a number is divided by a divisor.
Syntax:- =Mod(Number,
Divisor)
E.g. =Mod(23,4)
Press Enter
Output 3
8) Round()
Round function rounds the
number to specified number of digits.
Syntax:- =Round(No,
Num Digit)
E.g. =Round(34.267,2)
Press Enter
Output 34.27
9) Even()
Even function rounds a
positive number up and negative number dow to the nearest even integer.
Syntax:- =Sqrt(Number)
E.g. =Even(17)
Press Enter
Output 18
E.g. =Even(-17)
Press Enter
Output -18
10) Odd()
Odd function rounds a
positive number up and negative number down to the nearest odd integer.
Syntax:- =Sqrt(Number)
E.g. =Odd(22)
Press Enter
Output 23
E.g. =Odd(-22)
Press Enter
Output -23
11) Rand()
Rand function returns a
random number greter than or equal to 0 and less than 1.
Syntax:- =Rand()
12) ABS()
ABS function returns the
absolute value of number, a number without its sign.
Syntax:- =ABS(Number)
E.g. =ABS(-22)
Press Enter
Output 22
Also Read:-
2. Mathematical Function
3. Static Function
4. Date and Time Function
5. Logical Function