Home » Excel-2013-New-Functions
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 |
|---|
| DAYS | Returns the number of days between 2 dates |
| ISOWEEKNUM | Returns the ISO week number of the year for a given date |
| Engineering Functions |
|---|
| BITAND | Returns a Bitwise 'And' of two numbers |
| BITOR | Returns a Bitwise 'Or' of two numbers |
| BITLSHIFT | Returns a number shifted left by a specified number of bits |
| BITRSHIFT | Returns a number shifted right by a specified number of bits |
| BITXOR | Returns a Bitwise 'Exclusive Or' of two numbers |
| 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 |
| Financial Functions |
|---|
| PDURATION | Calculates the number of periods required for an investment to reach a specified value |
| RRI | Calculates an equivalent interest rate for the growth of an investment |
| Information Functions |
|---|
| ISFORMULA | Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE |
| SHEET | Returns the sheet number relating to a supplied reference |
| SHEETS | Returns the number of sheets in a reference |
| Logical Functions |
|---|
| IFNA | Tests 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 |
| XOR | Returns a logical Exclusive Or of all arguments |
| Lookup Function |
|---|
| FORMULATEXT | Returns a formula as a string |
| Math & Trigonometry Functions |
|---|
| ARABIC | Converts a Roman numeral to an Arabic numeral |
| ACOT | Returns the arccotangent of a number |
| ACOTH | Returns the hyperbolic arccotangent of a number |
| BASE | Converts a number into a text representation, with the supplied base |
| CEILING.MATH | Rounds a number up to the nearest integer or to the nearest multiple of significance |
| COMBINA | Returns the number of combinations (with repetitions) for a given number of items |
| COT | Returns the cotangent of an angle |
| COTH | Returns the hyperbolic cotangent of an angle |
| CSC | Returns the cosecant of an angle |
| CSCH | Returns the hyperbolic cosecant of an angle |
| DECIMAL | Converts a text representation of a number in a specified base into a decimal number |
| FLOOR.MATH | Rounds a number down, to the nearest integer or to the nearest multiple of significance |
| MUNIT | Returns the unit matrix for a specified dimension |
| SEC | Returns the secant of an angle |
| SECH | Returns the hyperbolic secant of an angle |
| Statistical Function |
|---|
| BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution |
| GAMMA | Return the gamma function value for a supplied number |
| GAUSS | Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean |
| PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
| PHI | Returns the value of the density function for a standard normal distribution, for a supplied number |
| SKEW.P | Returns the skewness of a distribution based on a population |
| Text Functions |
|---|
| NUMBERVALUE | Converts text to a number, in a locale-independent way |
| UNICHAR | Returns the Unicode character that is referenced by the given numeric value |
| UNICODE | Returns the number (code point) corresponding to the first character of a supplied text string |
| Web Functions |
|---|
| ENCODEURL | Returns a URL-encoded string |
| FILTERXML | Returns data from XML content, using a specified XPath |
| WEBSERVICE | Returns data from a web service on the Internet or Intranet |