New Functions in 2013

Excel 2013 introduced 50 new worksheet functions.

ACOTReturns the arccotangent of a number.
ACOTHReturns the hyperbolic arccotangent 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.
ISFORMULAReturns the boolean value depending if the cell contains a formula.
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.
ACOT
Returns the arccotangent of a number.
ACOTH
Returns the hyperbolic arccotangent of a number.
ARABIC
Returns the number converted from roman to arabic.
BASE
Returns the number converted into a text representation with the given base.
BINOM.DIST.RANGE
Returns the probablity of a trial result using a binomial distribution.
BITAND
Returns the bitwise and of two numbers.
BITLSHIFT
Returns a number shifted left by a number of bits.
BITOR
Returns the bitwise or of two numbers.
BITRSHIFT
Returns a number shifted right by a number of bits.
BITXOR
Returns a bitwise exclusive or of two numbers.
CEILING.MATH
Returns a number rounded up to the nearest integer or to the nearest significant figure.
COMBINA
Returns the number of combinations with repetitions for a given number of items.
COT
Returns the hyperbolic cosine of a number.
COTH
Returns the cotangent of an angle.
CSC
Returns the cosecant of an angle.
CSCH
Returns the hyperbolic cosecant of an angle.
DAYS
Returns the number of days between two dates.
DECIMAL
Returns the decimal number of a text representation of a number in a given base.
ENCODEURL
Returns a url encoded string.
FILTERXML
Returns specific data from the XML content by using Xpath.
FLOOR.MATH
Returns a number rounded to the nearest integer in a given base into a decimal number.
FORMULATEXT
Returns the formula from a particular cell.
GAMMA
Returns the gamma function value.
GAUSS
Returns 0.5 less than the standard normal cumulative distribution.
IFNA
Returns the boolean value depending if the value is #N/A.
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.
ISFORMULA
Returns the boolean value depending if the cell contains a formula.
ISOWEEKNUM
Returns the number of the ISO week of the year for a given date.
MUNIT
Returns the unit matrix or the specified dimension.
NUMBERVALUE
Returns the text to number in a locale independent manner.
PDURATION
Returns the number of periods required by an investment to reach a specified value.
PERMUTATIONA
Returns the number of permutations for a subset of objects or events (with repetition).
PHI
Returns the valueof the density function for a standard normal distribution.
RRI
Returns an equivalent interest rate for the growth of an investment.
SEC
Returns the secant of an angle.
SECH
Returns the hyperbolic secant of an angle.
SHEET
Returns the sheet number of the referenced sheet.
SHEETS
Returns the number of sheets in a reference.
SKEW.P
Returns the skewness of a distribution based on a population.
UNICHAR
Returns the unicode character that is references by the given numeric value.
UNICODE
Returns the number that corresponds to the first character of the text.
WEBSERVICE
Returns data from a webservice.
XOR
Returns the logical exclusive or for any number of arguments.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext