Get Excel 2013’s new functions added to your current version of Excel
Excel 2013 introduced 50 new worksheet functions. Excel PowerUps adds all 50 of the functions by installing a custom add-in for Excel. The Excel PowerUps work with the available 32-bit and 64-bit versions of Excel (2003, 2007, 2010, and even 2013). Excel 2013 not required!
Custom add-in function list (Excel 2013 New Functions)
In the listing below you can see the name of the Excel 2013 function (in ALL CAPS). The name of the corresponding Excel PowerUp function is in bold letters, and is prefixed by the letters “pwr” in Excel 2013. In other versions of Excel the function names are the same as Excel 2013.
- ACOT – returns the arccotangent of a number
- ACOTH – returns the hyperbolic arccotangent of a number
- ARABIC – converts a Roman numeral to an equivalent decimal number
- BASE – converts a number into the text representation of the same number with a given radix (base) value
- BINOM.DIST.RANGE – returns the probability of a trial result using a binomial distribution function
- BITAND – returns a bitwise AND of two numbers
- BITLSHIFT – returns a value number shifted left by a given number of bits
- BITOR – returns a bitwise OR of two numbers
- BITRSHIFT – returns a value number shifted right by a given number of bits
- BITXOR – returns a bitwise XOR (exclusive OR) of two numbers
- 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 a number
- COTH – returns the hyperbolic cotangent of a number
- CSC – returns the cosecant of a number
- CSCH – returns the hyperbolic cosecant of an angle
- DAYS – returns the number of days between two dates
- DECIMAL – converts a text representation of a number in a given base into a decimal number
- ENCODEURL – returns a URL-encoded string
- FILTERXML – returns specific data from the XML content by using the specified XPath
- FLOOR.MATH – rounds a number down, to the nearest integer or to the nearest multiple of significance
- FORMULATEXT – returns the formula at the given reference
- GAMMA – returns the Gamma function value
- GAUSS – returns the value of the standard normal deviation
- IFNA – returns the value you specify if the expression resolves to “#N/A” otherwise the value of the expression is returned
- 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 TRUE if there is a reference to a cell that contains a formula
- ISOWEEKNUM – returns the number of the ISO week number of the year for the given date
- MUNIT – returns the unit matrix of the specified dimension
- NUMBERVALUE – converts text to number in a locale-independent manner
- PDURATION – returns the number of periods required for an investment to reach a certain value
- PERMUTATION – 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
- 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 number of the current sheet
- SHEETS – returns the number of sheets in a reference (3D references not supported)
- SKEW.P – returns the skew value
- UNICHAR – returns the Unicode character that is referenced by the given numeric value
- UNICODE – returns the number (code point) that corresponds to the first character of the text
- WEBSERVICE – returns the data from the webservice
- XOR – returns a logical exclusive OR of all the arguments
Want to get the PowerUps?
The Excel PowerUps have been bundled into the Excel PowerUps Premium Suite. In addition to the new custom functions listed above, the Excel PowerUps Premium Suite includes the Excel Field Validator, the Excel Randomizer, the Excel Text Analyzer, and the Excel Web Assistant functions.
