### New Functions in 2013

Excel 2013 introduced 50 new worksheet functions.

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. |

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. |

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