Excel PowerUps Functions

Home / Help & Support / PowerUp Function Reference / Excel PowerUps 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”.

  • 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) – returns the GAUSS approximation value
  • 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) – returns the sheet number
  • SHEETS (pwrSHEETS) – returns the number of sheets in a reference (does not support 3d references)
  • 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

Leave a Reply

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