How you can add the 50 New Functions in Excel 2013 to your old copy of Excel

Excel add-in to power up older versions of Excel

Excel 2013 has been released and it looks like there are about 50 new worksheet functions added. Now you can get a matching function for each of the new Excel 2013 functions that has the same name and same parameters.

LEARN MOREGIVE IT A TRYBUY TODAY
Learn more about the great additions available for Excel 2013, 2010, 2007, and 2003.Download a free trial version. Trial versions are fully functional.
  • Select this option for a license you can activate on a single PC.

  • Select this option for a license you can activate on up to 3 PCs. This is perfect if you have a desktop, laptop, and a home PC you need to move your work across.

  • This option allows for up to 25 activations on the license. Share the license with your team, and have enough for your multiple workstations each. Need even more? Stack up multiple Single Activations and consult the volume licensing table for discount rates.

BUY

For volume purchases, see the Volume Pricing Table.

Excel 2013 new functions available for your old version of Excel

The listing below shows the Excel 2013 new function that is available for Excel 2010, 2007 and 2003. The matching Excel PowerUps function is in parentheses after the name and can be used within Excel 2013 as well. You’ll notice that each of the PowerUp functions has a prefix of “pwr”. This is done to avoid name collisions with other functions you may have. All you need to do is install the add-in pack and your copy of Excel will have the matching function as noted below.

  • ACOT (pwrACOT) – returns the arccotangent of a number
  • ACOTH (pwrACOTH) – returns the hyperbolic arccotangent of a number
  • ARABIC (pwrARABIC) – converts a Roman numeral to an equivalent decimal number
  • BASE (pwrBASE) – converts a number into the text representation of the same number with a given radix (base) value
  • BINOM.DIST.RANGE (pwrBINOMDISTRANGE) – returns the probability of a trial result using a binomial distribution function
  • BITAND (pwrBITAND) – returns a bitwise AND of two numbers
  • BITLSHIFT (pwrBITLSHIFT) – returns a value number shifted left by a given number of bits
  • BITOR (pwrBITOR) – returns a bitwise OR of two numbers
  • BITRSHIFT (pwrBITRSHIFT) – returns a value number shifted right by a given number of bits
  • BITXOR (pwrBITXOR) – returns a bitwise XOR (exclusive OR) of two numbers
  • CEILING.MATH (pwrCEILING) – rounds a number up, to the nearest integer or to the nearest multiple of significance
  • COMBINA (pwrCOMBINA) – returns the number of combinations with repetitions for a given number of items
  • COT (pwrCOT) – returns the cotangent of a number
  • COTH (pwrCOTH) – returns the hyperbolic cotangent of a number
  • CSC (pwrCSC) – returns the cosecant of a number
  • CSCH (pwrCSCH) – returns the hyperbolic cosecant of an angle
  • DAYS (pwrDAYS)- returns the number of days between two dates
  • DECIMAL (pwrDECIMAL) – converts a text representation of a number in a given base into a decimal number
  • ENCODEURL (pwrENCODEURL) – returns a URL-encoded string
  • FILTERXML (pwrFILTERXML) – returns specific data from the XML content by using the specified XPath
  • FLOOR.MATH (pwrFLOOR) – rounds a number down, to the nearest integer or to the nearest multiple of significance
  • FORMULATEXT (pwrFORMULATEXT) – returns the formula at the given reference
  • GAMMA (pwrGAMMA) – returns the Gamma function value
  • GAUSS (pwrGAUSS)
  • IFNA (pwrIFNA) – returns the value you specify if the expression resolves to “#N/A” otherwise the value of the expression is returned
  • IMCOSH (pwrIMCOSH) – returns the hyperbolic cosine of a complex number
  • IMCOT (pwrIMCOT) – returns the cotangent of a complex number
  • IMCSC (pwrIMCSC) – returns the cosecant of a complex number
  • IMCSCH (pwrIMCSCH) – returns the hyperbolic cosecant of a complex number
  • IMSEC (pwrIMSEC) – returns the secant of a complex number
  • IMSECH (pwrIMSECH) – returns the hyperbolic secant of a complex number
  • IMSINH (pwrIMSINH) – returns the hyperbolic sine of a complex number
  • IMTAN (pwrIMTAN) – returns the tangent of a complex number
  • ISFORMULA (pwrISFORMULA) – returns TRUE if there is a reference to a cell that contains a formula
  • ISOWEEKNUM (pwrISOWEEKNUM) – returns the number of the ISO week number of the year for the given date
  • MUNIT (pwrMUNIT) – returns the unit matrix of the specified dimension
  • NUMBERVALUE (pwrNUMBERVALUE) – converts text to number in a locale-independent manner
  • PDURATION (pwrPDURATION) – returns the number of periods required for an investment to reach a certain value
  • PERMUTATION (pwrPERMUTATION) – returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
  • PHI (pwrPHI) – returns the value of the density function for a standard normal distribution
  • RRI (pwrRRI) – returns an equivalent interest rate for the growth of an investment
  • SEC (pwrSEC) – returns the secant of an angle
  • SECH (pwrSECH) – returns the hyperbolic secant of an angle
  • SHEET (pwrSHEET)
  • SHEETS (pwrSHEETS)
  • SKEW.P (pwrSKEW.P)
  • UNICHAR (pwrUNICHAR) – returns the Unicode character that is referenced by the given numeric value
  • UNICODE (pwrUNICODE) – returns the number (code point) that corresponds to the first character of the text
  • WEBSERVICE (pwrWEBSERVICE) – returns the data from the webservice
  • XOR (pwrXOR) – returns a logical exclusive OR of all the arguments

There are additional custom add-on functions included in Excel PowerUps as well. In another post I’ll write about some of those. If you would like to check out the Excel PowerUps, go to https://officepowerups.com/products/excel-based-add-ins/office-powerups-excel-premium/.

Are there functions you wish Excel had but haven’t found? Let me know!

Leave a Reply

Your email address will not be published. Required fields are marked *