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