41. QUOTIENT:- In Microsoft Excel “QUOTIENT” function returns the result of a division.
Syntax of QUOTIENT function:-
=QUOTIENT(numerator,denominator)
Argument:-
numerator:- A number to be divided.
denominator:- The divisor.
Example of QUOTIENT function:-
The
following pictures show the example of the
QUOTIENT function.
42. RAND:- In Microsoft Excel “RAND” function returns the random
number between 0 and 1 and it recalculates when worksheet is changed or opened.
Syntax of RAND function:-
=RAND()
Argument:-
Example of RAND function:-
The
following pictures show the example of the
RAND function.
43. RANDBETWEEN:- In Microsoft Excel “RANDBETWEEN” function returns the
random integer between given two number.
Syntax of RANDBETWEEN function:-
=RANDBETWEEN(bottom,top)
Argument:-
bottom:- The first or lower value of the
range.
top:- The second or upper value of the
range.
Example of RANDBETWEEN function:-
The
following pictures show the example of the
RANDBETWEEN function.
44. ROMAN:- In Microsoft Excel “ROMAN” function converts a number to
roman form in text.
Syntax of ROMAN function:-
=ROMAN(number,[form])
Argument:-
number:- The number to be converted.
form:- The type of roman numerical and it is
an optional part and if omitted then default is 0 or TRUE (Classic form).
|
0 |
Classic Form |
|
1 or 2 or 3 |
More Concise |
|
4 |
Simplified Form |
|
TRUE |
Classic Form |
|
FALSE |
Simplified Form |
Example of ROMAN function:-
The
following pictures show the example of the
ROMAN function.
The table
below list are roman number with there equivalent Arabic number value.
|
SYMBOL |
VALUE |
|
I |
1 |
|
V |
5 |
|
X |
10 |
|
L |
50 |
|
C |
100 |
|
D |
500 |
|
M |
1000 |
45. ROUND:- In Microsoft Excel “ROUND” function returns a number
rounded to a given number of specific digits.
Syntax of ROUND function:-
=ROUND(number,num_digits)
Argument:-
number:- The number to round up.
num_digits:- The number should be rounded
according to the number of digits.
Example of ROUND function:-
The
following pictures show the example of the
ROUND function.
46. ROUNDDOWN:- In Microsoft Excel “ROUNDDOWN” function rounds a number
down toward zero.
Syntax of ROUNDDOWN function:-
=ROUNDDOWN(number,num_digits)
Argument:-
number:- The number to be rounded.
num_digits:- The number should be rounded
according to the number of digits.
Example of ROUNDDOWN function:-
The
following pictures show the example of the
ROUNDDOWN function.
47. ROUNDUP:- In Microsoft Excel “ROUNDUP” function rounds a number up
away from zero.
Syntax of ROUNDUP function:-
=ROUNDUP(number,num_digits)
Argument:-
number:- The number to be rounded.
num_digits:- The number should be rounded
according to the number of digits.
Example of ROUNDUP function:-
The following pictures show the example of the ROUNDUP function.
It is
calculated by the following formula :-
=SERIESSUM(x,m,n,coefficients) = a1xn
+ a2x(n+m) +……+ aix{n+(i-1)m}
Syntax of SERIESSUM function:-
=SERIESSUM(x,n,m,coefficients)
Argument:-
x:- The input value to the power series.
n:- The initial power to raise “x”.
m:- The step to increase “n” for each
term in the series.
coefficients:- The set of coefficients by which each
successive power “x” is multiplied.
Example of SERIESSUM function:-
The
following pictures show the example of the
SERIESSUM function.
49. SIGN:- In Microsoft Excel “SIGN” function returns the sign of a
number as +1,-1 or 0. If number is positive, SIGN function returns 1.
If number is negative SIGN function
returns -1. And if number is 0 then SIGN function returns zero (0).
Syntax of SIGN function:-
=SIGN(number)
Argument:-
number:- The number to get the SIGN of.
Example of SIGN function:-
The
following pictures show the example of the
SIGN function.
50. SQRT:- In Microsoft Excel “SQRT” function returns the square root
of a number.
Syntax of SQRT function:-
=SQRT(number)
Argument:-
number:- The number to find the square root
of.
Example of SQRT function:-
The
following pictures show the example of the
SQRT function.
51. SUBTOTAL:- In Microsoft Excel “SUBTOTAL” function returns a result
for supplied values. SUBTOTAL can
return a SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, etc. (see
table below) and Microsoft Excel “SUBTOTAL”
function can include or exclude values in hidden rows.
Syntax of SUBTOTAL function:-
=SUBTOTAL(function_num,ref1,….)
Argument:-
function_num:- A number is specified for which
function to use in calculating. The functions list is can see the table below
for details.
ref1:- A range or reference to subtotal.
ref2:- A range or reference to subtotal. It
is an optional part.
Example of SUBTOTAL function:-
The
following pictures show the example of the
SUBTOTAL function.
52. SUM:- In Microsoft Excel “SUM” function returns the sum of value
which is supplied from cell reference, range, arrays and constants, in any
combination and the sum function can handle up to 255 individual arguments.
Syntax of SUM function:-
=SUM(number1,[number2],……)
Argument:-
number1:- The first value to sum.
number2:- The second value to sum.
Example of SUM function:-
The
following pictures show the example of the
SUM function.
53. SUMIF:- In Microsoft Excel “SUMIF” function returns the total sum
of cells with a single condition. The SUMIF
function supported logical operators i.e. (>,
< ,<>, =).
Syntax of SUMIF function:-
=SUMIF(range,criteria,[sum_range])
Argument:-
range:- Against the criteria the range of
cells that you want to apply for.
criteria:- The condition (criteria) to determine
this specific cells to add.
sum_range:- The sum range is applied to add cells
together. It is an optional part. If omitted the cells in range is added
automatically.
Example of SUMIF function:-
The
following pictures show the example of the
SUMIF function.
54. SUMIFS:- In Microsoft Excel “SUMIFS” function returns the total sum
of cells with multiple conditions. The SUMIF
function supported logical operators i.e. (>,
< ,<>, =).
Syntax of SUMIFS function:-
=SUMIFS(sum_range,criteria_range1,criteria1,
[criteria_range2],[criteria2],….)
Argument:-
sum_range:- The sum range is applied to add cells
together.
criteria_range1:- The first criteria range.
criteria1:- The criteria to use on range1.
criteria_range2:- The second criteria range.
criteria2:- The criteria to use on range2.
Example of SUMIFS function:-
The
following pictures show the example of the
SUMIFS function.
55. SUMPRODUCT:- In Microsoft Excel “SUMPRODUCT” function multiplies a
range of cells together and returns the sum of the product.
Syntax of SUMPRODUCT function:-
=SUMPRODUCT(array1,[array2],[array3],….)
Argument:-
array1:- The first range to multiply then add.
array2:- The second range to multiply then
add. It is an optional part.
array3:- The second range to multiply then
add. It is an optional part.
Example of SUMPRODUCT function:-
The
following pictures show the example of the
SUMPRODUCT function.
56. SUMSQ:- In Microsoft Excel “SUMSQ” function returns the sum of
squares of a range of value.
Syntax of SUMSQ function:-
=SUMSQ(number1,[number2],….)
Argument:-
number1:- The first numeric values or array of
numeric values.
number2:- The second numeric values or array of
numeric values. It is an optional part.
Example of SUMSQ function:-
The
following pictures show the example of the
SUMSQ function.
57. SUMX2MY2:- In Microsoft Excel “SUMX2MY2” function returns the sum of
the difference of squares between two arrays or range of cells.
Syntax of SUMX2MY2 function:-
=SUMX2MY2(array_x,array_y)
Argument:-
array_x:- The first range used in the
calculation.
array_y:- The second range used in the
calculation.
Example of SUMX2MY2 function:-
The
following pictures show the example of the
SUMX2MY2 function.
58. SUMX2PY2:- In Microsoft Excel “SUMX2PY2” function calculates the sum
of the squares of corresponding values in the range and returns the sum of the
results.
Syntax of SUMX2PY2 function:-
=SUMX2PY2(array_x,array_y)
Argument:-
array_x:- The first array used in calculation.
array_y:- The second array used in calculation.
Example of SUMX2PY2 function:-
The
following pictures show the example of the
SUMX2PY2 function.
59. SUMXMY2:- In Microsoft Excel “SUMXMY2” function returns the sum of
the squares of difference between two supplied arrays.
Syntax of SUMXMY2 function:-
=SUMXMY2(array_x,array_y)
Argument:-
array_x:- The first array used in calculation.
array_y:- The second array used in calculation.
Example of SUMXMY2 function:-
The
following pictures show the example of the
SUMXMY2 function.
60. TRUNC:- In Microsoft Excel “TRUNC” function returns truncated
number to a specific number of digits.
Syntax of TRUNC function:-
=TRUNC(number,[num_digits])
Argument:-
number:- The number to truncate.
num_digits:- It is the number of the decimal
places to display in the truncated result. It is an optional part and if
omitted the TRUNC function assume zero in the decimal place.
Example of TRUNC function:-
The
following pictures show the example of the
TRUNC function.
0 Comments:
Post a Comment