21. ABS:- In Microsoft Excel “ABS” function returns the absolute
value (i.e. modulus of a number).
Syntax of ABS function:-
=ABS(number)
Argument:-
number:- The absolute value of the number that
you want.
Example of ABS function:-
The following
pictures show the example of the ABS
function.
22. CEILING:- In Microsoft Excel “CEILING” function rounds a given
significance number up to the nearest particularized multiple.
Syntax of CEILING function:-
=CEILING(number,significance)
Argument:-
number:- The number to be rounded.
significance:- The multiple to use when rounding the
number.
Example of CEILING function:-
The
following pictures show the example of the CEILINGfunction.
23. COMBIN:- In Microsoft Excel “COMBIN” function returns the number of
combination of a given number of items.
Syntax of COMBIN function:-
=COMBIN(number,number_chosen)
Argument:-
number:- The total number of items.
number_chosen:- The number of items in each
combination.
Example of COMBIN function:-
The
following pictures show the example of the
COMBIN function.
24. EVEN:- In Microsoft Excel “EVEN” function returns the nearest
even integer after rounding a given number up. It rounds positive number up and
negative number down.
Syntax of EVEN function:-
=EVEN(number)
Argument:-
number:- The number to round up to an even
integer.
Example of EVEN function:-
The
following pictures show the example of the
EVEN function.
25. EXP:- In Microsoft Excel “EXP” function returns the result of
the constant e raised to the power of a given number. The approximate value of
e is 2.71828182846.
Syntax of EXP function:-
=EXP(number)
Argument:-
number:- The number (the power that e is
raised to).
Example of EXP function:-
The
following pictures show the example of the
EXP function.
26. FACT:- In Microsoft Excel “FACT” function returns the factorial
of a given number.
Syntax of FACT function:-
=FACT(number)
Argument:-
number:- The positive integer to get the
factorial.
Example of FACT function:-
The
following pictures show the example of the
FACT function.
27. FACTDOUBLE:- In Microsoft Excel “FACTDOUBLE” function returns the
double factorial of a given number. It is calculated as below :-
a) Even:-
N*N-2*N-4*…..*4*2
b) Odd:-
N*N-2*N-4*…..*3*1
Syntax of FACTDOUBLE function:-
=FACTDOUBLE(number)
Argument:-
number:- The positive integer to get the
double factorial.
Example of FACTDOUBLE function:-
The
following pictures show the example of the
FACTDOUBLE function.
28. FLOOR:- In Microsoft Excel “FLOOR” function rounds a given number,
down to the nearest specified multiple of the significance.
Syntax of FLOOR function:-
=FLOOR(number,significance)
Argument:-
number:- The number to be rounded.
significance:- The multiple to use when rounding the
number.
Example of FLOOR function:-
The
following pictures show the example of the
FLOOR function.
29. GCD:- In Microsoft Excel “GCD” function returns the greatest
common divisor of two or more integers.
Syntax of GCD function:-
=GCD(number1,[number2],….)
Argument:-
number1:- The first number for GCD calculation.
number2:- The first number for GCD calculation.
It is an optional part.
Example of GCD function:-
The
following pictures show the example of the
GCD function.
30. INT:- In Microsoft Excel “INT” function returns the integer
portion of a decimal number by rounding down to the integer.
Syntax of INT function:-
=INT(number)
Argument:-
number:- The number from which you want to
round down.
Example of INT function:-
The
following pictures show the example of the
INT function.
31. LCM:- In Microsoft Excel “LCM” function returns the least common
multiple of two or more integers. The least common multiples are smallest
positive integer and i.e. multiple of supplied numbers.
Syntax of LCM function:-
=LCM(number1,[number2])
Argument:-
number1:- The first number for LCM calculation.
number2:- The second number for LCM
calculation. It is an optional part.
Example of LCM function:-
The
following pictures show the example of the
LCM function.
32. MDETERM:- In Microsoft Excel “MDETERM” function returns the
determinant of a square matrix or an array.
Syntax of MDETERM function:-
=MDETERM(array)
Argument:-
array:- The square matrix to be calculated.
Example of MDETERM function:-
The
following pictures show the example of the
MDETERM function.
33. MINVERSE:- In Microsoft Excel “MINVERSE” function returns the inverse
matrix of a given array (The input array must contain only numbers).
Syntax of MINVERSE function:-
=MINVERSE(array)
Argument:-
array:- A array of numbers only.
Example of MINVERSE function:-
The
following pictures show the example of the
MINVERSE function.
34. MMULT:- In Microsoft Excel “MMULT” function returns the matrix
product of two arrays. Number of rows in
array 1 is equal to number of columns in array2 and vice versa.
Syntax of MMULT function:-
=MMULT(array1,array2)
Argument:-
array1:- The first array to calculate the
matrix product.
array2:- The second array to calculate the
matrix product.
Example of MMULT function:-
The
following pictures show the example of the
MMULT function.
35. MOD:- After a number is divided by a
divisor the Microsoft Excel “MOD” function
returns the reminder.
Syntax of MOD function:-
=MOD(number,divisor)
Argument:-
number:- The number to be divided.
divisor:- The number to divide with.
Example of MOD function:-
The
following pictures show the example of the
MOD function.
36. MROUND:- In Microsoft Excel “MROUND” function returns a rounded
number to a given multiple. MROUND function will round a number up or down and
it depends on the nearest multiple number.
Syntax of MROUND function:-
=MROUND(number,multiple)
Argument:-
number:- The number to be rounded.
multiple:- The multiple to use when rounding.
Example of MROUND function:-
The
following pictures show the example of the
MROUND function.
37. MULTINOMIAL:- In Microsoft Excel “MULTINOMIAL” function calculates the
ratio of the factorial of a sum of supplied number to the product of factorials
of those given numbers.
Syntax of MULTINOMIAL function:-
=MULTINOMIAL(number1,[number2],….)
Argument:-
number1:- First integer to calculate.
number2:- Second integer to calculate and it is
an optional part.
Example of MULTINOMIAL function:-
The
following pictures show the example of the
MULTINOMIAL function.
38. ODD:- After rounding a given number, Microsoft Excel “ODD” function returns the next odd integer.
N.B.:- Positive number becomes larger and
negative number becomes smaller.
Syntax of ODD function:-
=ODD(number)
Argument:-
number:- The number to round up to an odd
integer.
Example of ODD function:-
The
following pictures show the example of the
ODD function.
39. POWER:- In Microsoft Excel “POWER” function returns the result of
a number increased to a given power.
Syntax of POWER function:-
=POWER(number,power)
Argument:-
number:- The number to increase to a power.
power:- Exponent to raise power to number.
Example of POWER function:-
The
following pictures show the example of the
POWER function.
40. PRODUCT:- In Microsoft Excel “PRODUCT” function multiplies all the
numbers given as arguments.
Syntax of PRODUCT function:-
=PRODUCT(number1,[number2],…..)
Argument:-
number1:- The first number or range of numbers
to calculate the product.
number2:- The second number or range of numbers
to calculate the product and it is an optional part.
Example of PRODUCT function:-
The
following pictures show the example of the
PRODUCT function.
0 Comments:
Post a Comment