New Functions in 2013
Excel 2013 introduced 49 new worksheet functions.
| ACOT | Returns the arc-cotangent of a number. |
| ACOTH | Returns the hyperbolic arc-cotangent 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 probability 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. |
| 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 value of the density function for a standard normal distribution. |
| RRI | Returns the 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. |
| ACOT Returns the arc-cotangent of a number. |
| ACOTH Returns the hyperbolic arc-cotangent 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 probability 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. |
| 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 value of the density function for a standard normal distribution. |
| RRI Returns the 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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext