# Excel 2013 New Functions

Excel 2013 introduces several new functions, mainly in the Math, Statistical and Engineering categories. These are listed by category below:

Date & Time Functions
DAYS Returns the number of days between 2 dates
ISOWEEKNUM Returns the ISO week number of the year for a given date
Engineering Functions
BITAND Returns a Bitwise 'And' of two numbers
BITOR Returns a Bitwise 'Or' of two numbers
BITLSHIFT Returns a number shifted left by a specified number of bits
BITRSHIFT Returns a number shifted right by a specified number of bits
BITXOR Returns a Bitwise 'Exclusive Or' of two numbers
IMCOSH Returns the hyperbolic cosine of a complex number
IMCOT Returns the cotangent of a complex number
IMCSC Returns the cosecant of a complex number
IMCSCH Returns the hyperbolic cosecant of a complex number
IMSEC Returns the secant of a complex number
IMSECH Returns the hyperbolic secant of a complex number
IMSINH Returns the hyperbolic sine of a complex number
IMTAN Returns the tangent of a complex number
Financial Functions
PDURATION Calculates the number of periods required for an investment to reach a specified value
RRI Calculates an equivalent interest rate for the growth of an investment
Information Functions
ISFORMULA Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE
SHEET Returns the sheet number relating to a supplied reference
SHEETS Returns the number of sheets in a reference
Logical Functions
IFNA Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression
XOR Returns a logical Exclusive Or of all arguments
Lookup Function
FORMULATEXT Returns a formula as a string
Math & Trigonometry Functions
ARABIC Converts a Roman numeral to an Arabic numeral
ACOT Returns the arccotangent of a number
ACOTH Returns the hyperbolic arccotangent of a number
BASE Converts a number into a text representation, with the supplied base
CEILING.MATH Rounds a number up to the nearest integer or to the nearest multiple of significance
COMBINA Returns the number of combinations (with repetitions) for a given number of items
COT Returns the cotangent of an angle
COTH Returns the hyperbolic cotangent of an angle
CSC Returns the cosecant of an angle
CSCH Returns the hyperbolic cosecant of an angle
DECIMAL Converts a text representation of a number in a specified base into a decimal number
FLOOR.MATH Rounds a number down, to the nearest integer or to the nearest multiple of significance
MUNIT Returns the unit matrix for a specified dimension
SEC Returns the secant of an angle
SECH Returns the hyperbolic secant of an angle
Statistical Function
BINOM.DIST.RANGE Returns the probability of a trial result using a binomial distribution
GAMMA Return the gamma function value for a supplied number
GAUSS Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean
PERMUTATIONA Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI Returns the value of the density function for a standard normal distribution, for a supplied number
SKEW.P Returns the skewness of a distribution based on a population
Text Functions
NUMBERVALUE Converts text to a number, in a locale-independent way
UNICHAR Returns the Unicode character that is referenced by the given numeric value
UNICODE Returns the number (code point) corresponding to the first character of a supplied text string
Web Functions
ENCODEURL Returns a URL-encoded string
FILTERXML Returns data from XML content, using a specified XPath
WEBSERVICE Returns data from a web service on the Internet or Intranet