To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
Function | Description |
Returns the absolute value of a number | |
Returns the arccosine of a number | |
Returns the inverse hyperbolic cosine of a number | |
Returns the arccotangent of a number | |
Returns the hyperbolic arccotangent of a number | |
Returns the aggregate in a list or database | |
Converts a Roman number to Arabic, as a number | |
Returns the arcsine of a number | |
Returns the inverse hyperbolic sine of a number | |
Returns the arctangent of a number | |
Returns the arctangent from x- and y-coordinates | |
Returns the inverse hyperbolic tangent of a number | |
Converts a number into a text representation with the given radix (base) | |
Rounds a number to the nearest integer or to the nearest multiple of significance | |
Rounds a number up, to the nearest integer or to the nearest multiple of significance | |
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | |
Returns the number of combinations for a given number of objects | |
Returns the number of combinations with repetitions for a given number of items | |
Returns the cosine of a number | |
Returns the hyperbolic cosine of a number | |
Returns the cotangent of an angle | |
Returns the hyperbolic cotangent of a number | |
Returns the cosecant of an angle | |
Returns the hyperbolic cosecant of an angle | |
Converts a text representation of a number in a given base into a decimal number | |
Converts radians to degrees | |
Rounds a number up to the nearest even integer | |
Returns e raised to the power of a given number | |
Returns the factorial of a number | |
Returns the double factorial of a number | |
Rounds a number down, toward zero | |
Rounds a number down, to the nearest integer or to the nearest multiple of significance | |
Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down. | |
Returns the greatest common divisor | |
Rounds a number down to the nearest integer | |
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance | |
Returns the least common multiple | |
Returns the natural logarithm of a number | |
Returns the logarithm of a number to a specified base | |
Returns the base-10 logarithm of a number | |
Returns the matrix determinant of an array | |
Returns the matrix inverse of an array | |
Returns the matrix product of two arrays | |
Returns the remainder from division | |
Returns a number rounded to the desired multiple | |
Returns the multinomial of a set of numbers | |
Returns the unit matrix or the specified dimension | |
Rounds a number up to the nearest odd integer | |
Returns the value of pi | |
Returns the result of a number raised to a power | |
Multiplies its arguments | |
Returns the integer portion of a division | |
Converts degrees to radians | |
Returns a random number between 0 and 1 | |
Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. | |
Returns a random number between the numbers you specify | |
Converts an Arabic numeral to Roman, as text | |
Rounds a number to a specified number of digits | |
Rounds a number down, toward zero | |
Rounds a number up, away from zero | |
Returns the secant of an angle | |
Returns the hyperbolic secant of an angle | |
Returns the sum of a power series based on the formula | |
Returns the sign of a number | |
Returns the sine of the given angle | |
Returns the hyperbolic sine of a number | |
Returns a positive square root | |
Returns the square root of (number * pi) | |
Returns a subtotal in a list or database | |
Adds its arguments | |
Adds the cells specified by a given criteria | |
Adds the cells in a range that meet multiple criteria | |
Returns the sum of the products of corresponding array components | |
Returns the sum of the squares of the arguments | |
Returns the sum of the difference of squares of corresponding values in two arrays | |
Returns the sum of the sum of squares of corresponding values in two arrays | |
Returns the sum of squares of differences of corresponding values in two arrays | |
Returns the tangent of a number | |
Returns the hyperbolic tangent of a number | |
Truncates a number to an integer |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
You need personal informations from companies,family and friends that will better your life and you need easy access without them noticing or you’re financially unstable and you have a bad credit score, come to Brillianthackers800@gmail.com he will solve that without stress,he and his team can clear criminal records without leaving a trace and can also anonymously credit your empty credit cards with funds you need,all these things and more this hacker and his team will do cause they keep you updated on every step taken in order to achieve the goal and they also deliver on time,I tested and confirmed this I’m still happy on how my life is improving after my encounter with them, you can send a mail to Brillianthackers800@gmail.com
ReplyDelete