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
ACOT function Math and trigonometry:    Returns the arccotangent of a number
ACOTH function Math and trigonometry:    Returns the hyperbolic arccotangent of a number
ARABIC function Math and trigonometry:    Converts a Roman number to Arabic, as a number
BASE function Math and trigonometry:    Converts a number into a text representation with the given radix (base)
BINOM.DIST.RANGE function Statistical:    Returns the probability of a trial result using a binomial distribution
BITAND function Engineering:    Returns a 'Bitwise And' of two numbers
BITLSHIFT function Engineering:    Returns a value number shifted left by shift_amount bits
BITOR function Engineering:    Returns a bitwise OR of 2 numbers
BITRSHIFT function Engineering:    Returns a value number shifted right by shift_amount bits
BITXOR function Engineering:    Returns a bitwise 'Exclusive Or' of two numbers
CEILING.MATH function Math and trigonometry:    Rounds a number up, to the nearest integer or to the nearest multiple of significance
COMBINA function Math and trigonometry:   
Returns the number of combinations with repetitions for a given number of items
COT function Math and trigonometry:    Returns the hyperbolic cosine of a number
COTH function Math and trigonometry:    Returns the cotangent of an angle
CSC function Math and trigonometry:    Returns the cosecant of an angle
CSCH function Math and trigonometry:    Returns the hyperbolic cosecant of an angle
DAYS function Date and time:    Returns the number of days between two dates
DECIMAL function Math and trigonometry:    Converts a text representation of a number in a given base into a decimal number
ENCODEURL function Web:    Returns a URL-encoded string
FILTERXML function Web:    Returns specific data from the XML content by using the specified XPath
FLOOR.MATH function Math and trigonometry:    Rounds a number down, to the nearest integer or to the nearest multiple of significance
FORMULATEXT function Lookup and reference:    Returns the formula at the given reference as text
GAMMA function Statistical:    Returns the Gamma function value
GAUSS function Statistical:    Returns 0.5 less than the standard normal cumulative distribution
IFNA function Logical:    Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IMCOSH function Engineering:    Returns the hyperbolic cosine of a complex number
IMCOT function Engineering:    Returns the cotangent of a complex number
IMCSC function Engineering:    Returns the cosecant of a complex number
IMCSCH function Engineering:    Returns the hyperbolic cosecant of a complex number
IMSEC function Engineering:    Returns the secant of a complex number
IMSECH function Engineering:    Returns the hyperbolic secant of a complex number
IMSINH function Engineering:    Returns the hyperbolic sine of a complex number
IMTAN function Engineering:    Returns the tangent of a complex number
ISFORMULA function Information:    Returns TRUE if there is a reference to a cell that contains a formula
ISOWEEKNUM function Date and time:    Returns the number of the ISO week number of the year for a given date
MUNIT function Math and trigonometry:    Returns the unit matrix or the specified dimension
NUMBERVALUE function Text:    Converts text to number in a locale-independent manner
PDURATION function Financial:    Returns the number of periods required by an investment to reach a specified value
PERMUTATIONA function Statistical:    Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI function Statistical:    Returns the value of the density function for a standard normal distribution
RRI function Financial:    Returns an equivalent interest rate for the growth of an investment
SEC function Math and trigonometry:    Returns the secant of an angle
SECH function Math and trigonometry:    Returns the hyperbolic secant of an angle
SHEET function Information:    Returns the sheet number of the referenced sheet
SHEETS function Information:    Returns the number of sheets in a reference
SKEW.P function Statistical:    Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
UNICHAR function Text:    Returns the Unicode character that is references by the given numeric value
UNICODE function Text:    Returns the number (code point) that corresponds to the first character of the text
WEBSERVICE function Web:    Returns data from a web service.
XOR function Logical:    Returns a logical exclusive OR of all arguments

Top of Page Top of Page

 
 
Applies to:
Excel 2013