# New Functions in 2013

Excel 2013 introduced 50 new worksheet functions.

 ACOTReturns the arc-cotangent of a number. ACOTHReturns the hyperbolic arc-cotangent of a number. ARABICReturns the number converted from roman to arabic. BASEReturns the number converted into a text representation with the given base. BINOM.DIST.RANGEReturns the probablity of a trial result using a binomial distribution. BITANDReturns the bitwise and of two numbers. BITLSHIFTReturns a number shifted left by a number of bits. BITORReturns the bitwise or of two numbers. BITRSHIFTReturns a number shifted right by a number of bits. BITXORReturns a bitwise exclusive or of two numbers. CEILING.MATHReturns a number rounded up to the nearest integer or to the nearest significant figure. COMBINAReturns the number of combinations with repetitions for a given number of items. COTReturns the hyperbolic cosine of a number. COTHReturns the cotangent of an angle. CSCReturns the cosecant of an angle. CSCHReturns the hyperbolic cosecant of an angle. DAYSReturns the number of days between two dates. DECIMALReturns the decimal number of a text representation of a number in a given base. ENCODEURLReturns a url encoded string. FILTERXMLReturns specific data from the XML content by using Xpath. FLOOR.MATHReturns a number rounded to the nearest integer in a given base into a decimal number. FORMULATEXTReturns the formula from a particular cell. GAMMAReturns the gamma function value. GAUSSReturns 0.5 less than the standard normal cumulative distribution. IFNAReturns the boolean value depending if the value is #N/A. 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. ISOWEEKNUMReturns the number of the ISO week of the year for a given date. MUNITReturns the unit matrix or the specified dimension. NUMBERVALUEReturns the text to number in a locale independent manner. PDURATIONReturns the number of periods required by an investment to reach a specified value. PERMUTATIONAReturns the number of permutations for a subset of objects or events (with repetition). PHIReturns the valueof the density function for a standard normal distribution. RRIReturns an equivalent interest rate for the growth of an investment. SECReturns the secant of an angle. SECHReturns the hyperbolic secant of an angle. SHEETReturns the sheet number of the referenced sheet. SHEETSReturns the number of sheets in a reference. SKEW.PReturns the skewness of a distribution based on a population. UNICHARReturns the unicode character that is references by the given numeric value. UNICODEReturns the number that corresponds to the first character of the text. WEBSERVICEReturns data from a webservice. XORReturns the logical exclusive or for any number of arguments.