# New functions in Excel 2013

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