50 new functions in Excel 2013

With Excel 2013, 50 new functions have been added. Here they are and for some of them, few extra explanations.

Most of them are dedicated for top level engineers or statisticians. But there is also some very useful functions for a daily practice of Excel.

Date and time

2 new Date and time functions. ISOWEEKNUM is a relief to convert a date with the correct week number for most of the country in the world.

  • DAYS: Returns the number of days between two dates
  • ISOWEEKNUM: Returns the number of the ISO week number of the year for a given date. You will find an example of this function in this article

Remark: DAYS is useless because you can return the number of days between 2 dates with a simple subtraction

Lookup and reference

This new function is brilliant to present to your audience the writing of your formula

  • FORMULATEXT: Returns the formula at the given reference as text
Example of the function FORMULATEXT

Text

3 new Text functions

  • NUMBERVALUE: Converts text to number in a locale-independent manner
  • UNICHAR: Returns the Unicode character that is references by the given numeric value
  • UNICODE: Returns the number (code point) that corresponds to the first character of the text

Logical

2 new logical functions

Financial

2 new financial functions

  • PDURATION: Returns the number of periods required by an investment to reach a specified value
  • RRI: Returns an equivalent interest rate for the growth of an investment

Information

3 new function is this section. SHEETS is interesting to count the number of worksheet in your workbook.

  • ISFORMULA: Returns TRUE if there is a reference to a cell that contains a formula
  • SHEET: Returns the sheet number of the referenced sheet
  • SHEETS: Returns the number of sheets in a reference

Web

3 new Web functions. In fact, the web function category is new. You can now directly return the content of a website in a cell.

  • ENCODEURL: Returns a URL-encoded string
  • FILTERXML: Returns specific data from the XML content by using the specified XPath
  • WEBSERVICE: Returns data from a web service

Math 

7 new math functions. CEILING.MATH and FLOOR.MATH are really interesting

  • ARABIC: Converts a Roman number to Arabic, as a number
  • BASE: Converts a number into a text representation with the given radix (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
  • DECIMAL: Converts a text representation of a number in a given 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 or the specified dimension

Statistical

6 new Statistical functions

  • BINOM.DIST.RANGE: Returns the probability of a trial result using a binomial distribution
  • GAMMA: Returns the Gamma value
  • GAUSS: Returns 0.5 less than the standard normal cumulative distribution
  • 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 for a standard normal distribution
  • SKEW.P: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean

Engineering

13 new functions in this section. They are only useful for top level engineer. For a basic use of Excel, they are not useful.

  • BITAND: Returns a ‘Bitwise And’ of two numbers
  • BITLSHIFT: Returns a value number shifted left by shift_amount bits
  • BITOR: Returns a bitwise OR of 2 numbers
  • BITRSHIFT: Returns a value number shifted right by shift_amount 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

Trigonometry

8 new trigonometric functions

  • ACOT: Returns the arccotangent of a number
  • ACOTH: Returns the hyperbolic arccotangent of a number
  • 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
  • SEC: Returns the secant of an angle
  • SECH: Returns the hyperbolic secant of an angle

Leave a Reply

Your email address will not be published.