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.
Click any function name in the following list to see detailed help about that function.
Function name |
Type and description |
Math and trigonometry: Returns the arccotangent of a number |
|
Math and trigonometry: Returns the hyperbolic arccotangent of a number |
|
Math and trigonometry: Converts a Roman number to Arabic, as a number |
|
Math and trigonometry: Converts a number into a text representation with the given radix (base) |
|
Statistical: Returns the probability of a trial result using a binomial distribution |
|
Engineering: Returns a 'Bitwise And' of two numbers |
|
Engineering: Returns a value number shifted left by shift_amount bits |
|
Engineering: Returns a bitwise OR of 2 numbers |
|
Engineering: Returns a value number shifted right by shift_amount bits |
|
Engineering: Returns a bitwise 'Exclusive Or' of two numbers |
|
Math and trigonometry: Rounds a number up, to the nearest integer or to the nearest multiple of significance |
|
Math and trigonometry: Returns the number of combinations with repetitions for a given number of items |
|
Math and trigonometry: Returns the hyperbolic cosine of a number |
|
Math and trigonometry: Returns the cotangent of an angle |
|
Math and trigonometry: Returns the cosecant of an angle |
|
Math and trigonometry: Returns the hyperbolic cosecant of an angle |
|
Date and time: Returns the number of days between two dates |
|
Math and trigonometry: Converts a text representation of a number in a given base into a decimal number |
|
Web: Returns a URL-encoded string |
|
Web: Returns specific data from the XML content by using the specified XPath |
|
Math and trigonometry: Rounds a number down, to the nearest integer or to the nearest multiple of significance |
|
Lookup and reference: Returns the formula at the given reference as text |
|
Statistical: Returns the Gamma function value |
|
Statistical: Returns 0.5 less than the standard normal cumulative distribution |
|
Logical: Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
|
Engineering: Returns the hyperbolic cosine of a complex number |
|
Engineering: Returns the cotangent of a complex number |
|
Engineering: Returns the cosecant of a complex number |
|
Engineering: Returns the hyperbolic cosecant of a complex number |
|
Engineering: Returns the secant of a complex number |
|
Engineering: Returns the hyperbolic secant of a complex number |
|
Engineering: Returns the hyperbolic sine of a complex number |
|
Engineering: Returns the tangent of a complex number |
|
Information: Returns TRUE if there is a reference to a cell that contains a formula |
|
Date and time: Returns the number of the ISO week number of the year for a given date |
|
Math and trigonometry: Returns the unit matrix or the specified dimension |
|
Text: Converts text to number in a locale-independent manner |
|
Financial: Returns the number of periods required by an investment to reach a specified value |
|
Statistical: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
|
Statistical: Returns the value of the density function for a standard normal distribution |
|
Financial: Returns an equivalent interest rate for the growth of an investment |
|
Math and trigonometry: Returns the secant of an angle |
|
Math and trigonometry: Returns the hyperbolic secant of an angle |
|
Information: Returns the sheet number of the referenced sheet |
|
Information: Returns the number of sheets in a reference |
|
Statistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |
|
Text: Returns the Unicode character that is references by the given numeric value |
|
Text: Returns the number (code point) that corresponds to the first character of the text |
|
Web: Returns data from a web service. |
|
Logical: Returns a logical exclusive OR of all arguments |