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
DAYSReturns the number of days between 2 dates
ISOWEEKNUMReturns the ISO week number of the year for a given date
Engineering Functions
BITANDReturns a Bitwise 'And' of two numbers
BITORReturns a Bitwise 'Or' of two numbers
BITLSHIFTReturns a number shifted left by a specified number of bits
BITRSHIFTReturns a number shifted right by a specified number of bits
BITXORReturns a Bitwise 'Exclusive Or' of two numbers
IMCOSHReturns the hyperbolic cosine of a complex number
IMCOTReturns the cotangent of a complex number
IMCSCReturns the cosecant of a complex number
IMCSCHReturns the hyperbolic cosecant of a complex number
IMSECReturns the secant of a complex number
IMSECHReturns the hyperbolic secant of a complex number
IMSINHReturns the hyperbolic sine of a complex number
IMTANReturns the tangent of a complex number
Financial Functions
PDURATIONCalculates the number of periods required for an investment to reach a specified value
RRICalculates an equivalent interest rate for the growth of an investment
Information Functions
ISFORMULATests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE
SHEETReturns the sheet number relating to a supplied reference
SHEETSReturns the number of sheets in a reference
Logical Functions
IFNATests 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
XORReturns a logical Exclusive Or of all arguments
Lookup Function
FORMULATEXTReturns a formula as a string
Math & Trigonometry Functions
ARABICConverts a Roman numeral to an Arabic numeral
ACOTReturns the arccotangent of a number
ACOTHReturns the hyperbolic arccotangent of a number
BASEConverts a number into a text representation, with the supplied base
CEILING.MATHRounds a number up to the nearest integer or to the nearest multiple of significance
COMBINAReturns the number of combinations (with repetitions) for a given number of items
COTReturns the cotangent of an angle
COTHReturns the hyperbolic cotangent of an angle
CSCReturns the cosecant of an angle
CSCHReturns the hyperbolic cosecant of an angle
DECIMALConverts a text representation of a number in a specified base into a decimal number
FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance
MUNITReturns the unit matrix for a specified dimension
SECReturns the secant of an angle
SECHReturns the hyperbolic secant of an angle
Statistical Function
BINOM.DIST.RANGEReturns the probability of a trial result using a binomial distribution
GAMMAReturn the gamma function value for a supplied number
GAUSSCalculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean
PERMUTATIONAReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHIReturns the value of the density function for a standard normal distribution, for a supplied number
SKEW.PReturns the skewness of a distribution based on a population
Text Functions
NUMBERVALUEConverts text to a number, in a locale-independent way
UNICHARReturns the Unicode character that is referenced by the given numeric value
UNICODEReturns the number (code point) corresponding to the first character of a supplied text string
Web Functions
ENCODEURLReturns a URL-encoded string
FILTERXMLReturns data from XML content, using a specified XPath
WEBSERVICEReturns data from a web service on the Internet or Intranet