Alphabetical Listing of Functions
The functions that provide the equivalent functions to Excel 2013 are listed in the middle column where they are applicable. Click on the function name to jump to the page specific to that function.
| Function Name | Forward Compatibility Name | Description |
|---|---|---|
| pwrACOT | ACOT | Return the arccotangent. |
| pwrACOTH | ACOTH | Return the hyperbolic arccotangent. |
| pwrADDRESSPART | Return part of an address. | |
| pwrARABIC | ARABIC | Convert a roman numeral to an arabic number. |
| pwrBASE | BASE | Converts a number into a text representation with the given radix (base). |
| pwrBINOM.DIST.RANGE | BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution. |
| pwrBITAND | BITAND | Returns the bitwise AND of values. |
| pwrBITLSHIFT | BITLSHIFT | Returns a number shifted left by the specified number of bits. |
| pwrBITOR | BITOR | Returns the bitwise OR of values. |
| pwrBITRSHIFT | BITRSHIFT | Returns a number shifted right by the specified number of bits. |
| pwrBITXOR | BITXOR | Returns a bitwise XOR of two numbers. |
| pwrCEILING.MATH | CEILING.MATH | Returns number rounded up, away from zero, to the nearest multiple of significance. |
| pwrCOMBINA | COMBINA | Returns the number of combinations (with repetitions) for a given number of items. |
| pwrCONCATENATE | Concatenates a range of cells, by row or by column, with optional delimiter. | |
| pwrCONTAINS | Returns whether a string is contained within another. | |
| pwrCONVERTDISTANCE | Converts distance values among various units. | |
| pwrCONVERTPOWER | Converts power values among various units. | |
| pwrCONVERTSTORAGE | Converts storage values among various units. | |
| pwrCONVERTTEMP | Converts temperature values among various units. | |
| pwrCONVERTTIME | Converts time values among various units. | |
| pwrCONVERTVOLUME | Converts volume values among various units. | |
| pwrCONVERTWEIGHT | Converts weight values among various units. | |
| pwrCOT | COT | Returns the cotangent of an angle specified in radians. |
| pwrCOTH | COTH | Returns the hyperbolic cotangent of a hyperbolic angle. |
| pwrCSC | CSC | Returns the cosecant of an angle specified in radians. |
| pwrCSCH | CSCH | Returns the hyperbolic cosecant of an angle specified in radians. |
| pwrCURRENTUSER | Returns the name of the currently logged on user. | |
| pwrDAYS | DAYS | Returns the number of days between two dates. |
| pwrDECIMAL | DECIMAL | Converts a text representation of a number in a given base into a decimal number. |
| pwrENCODEURL | ENCODEURL | Returns a URL-encoded string. |
| pwrFETCHXMLVIAGET | Return results of XML web service call using the GET method. | |
| pwrFETCHXMLVIAPOST | Return results of XML web service call using the POST method. | |
| pwrFILEEXISTS | Determine whether the specified file exists. Return TRUE if it exists, FALSE otherwise. | |
| pwrFILTERXML | FILTERXML | Returns specific data from the XML content by using the specified XPath. |
| pwrFLOOR.MATH | FLOOR.MATH | Round a number down to the nearest integer or to the nearest multiple of significance. |
| pwrFORMATXML | Format XML results with indentation. Must enable wrapping. | |
| pwrFORMULATEXT | FORMULATEXT | Returns a formula as a string. |
| pwrGAMMA | GAMMA | Return the gamma function value. |
| pwrGAUSS | GAUSS | Returns the GAUSS function approximation. |
| pwrGETQUERYSTRINGTOKENVALUE | Get the value of the specified querystring token. | |
| pwrHASH | Return a hash of the specified string using the provided method. | |
| pwrHLOOKUP | Perform a horizontal lookup for a value. Can be fuzzy. | |
| pwrHTMLENCODE | Return the HTML encoded version of a string. | |
| pwrHTMLUNENCODE | Return the HTML encoded string with encoded values unencoded. | |
| pwrIFNA | IFNA | Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula. |
| pwrIMCOSH | IMCOSH | Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format. |
| pwrIMCOT | IMCOT | Returns the cotangent of a complex number in x+yi or x+yj text format. |
| pwrIMCSC | IMCSC | Returns the cosecant of a complex number in x+yi or x+yj text format. |
| pwrIMCSCH | IMCSCH | Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format. |
| pwrIMSEC | IMSEC | Returns the secant of a complex number in x+yi or x+yj text format. |
| pwrIMSECH | IMSECH | Returns the hyperbolic secant of a complex number in x+yi or x+yj text format. |
| pwrIMSINH | IMSINH | Returns the hyperbolic sine of a complex number in x+yi or x+yj text format. |
| pwrIMTAN | IMTAN | Returns the tangent of a complex number in x+yi or x+yj text format. |
| pwrINPUTBOX | Prompts user to input text with input box, returns string entered. | |
| pwrISADDRESS | Determine whether the provided string matches the pattern of a postal address. Return TRUE, else return FALSE. | |
| pwrISBROKENURL | Determine whether the provided URL returns a page, or an error page. | |
| pwrISCREDITCARDNUMBER | Determine whether the provided string matches the pattern of a credit card number. | |
| pwrISDATE | Determine whether the provided string matches the pattern of a calendar date. Return TRUE, else return FALSE. | |
| pwrISEMAIL | Determine whether the provided string matches the pattern of an email address. Return TRUE, else return FALSE. | |
| pwrISFORMULA | ISFORMULA | Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE. |
| pwrISFULLURL | Determine whether the provided string matches the pattern of a complete URL. Return TRUE, else return FALSE. | |
| pwrISIPADDRESS | Determine whether the provided string matches the pattern of an IP address. Return TRUE, else return FALSE. | |
| pwrISOWEEKNUM | ISOWEEKNUM | Returns number of the ISO week number of the year for a given date. |
| pwrISPHONENUMBER | Determine whether the provided string matches the pattern of a phone number. Return TRUE, else return FALSE. | |
| pwrISREGEXMATCH | Perform a regular expression match. Return TRUE if matches. Return FALSE otherwise. | |
| pwrISZIPCODE | Determine whether the provided string matches the pattern of a zip code. Return TRUE, else return FALSE. | |
| pwrMATCH | Perform a MATCH operation. The MATCH criteria may be fuzzy. | |
| pwrMAYBE | Return TRUE based on Boolean AND plus likelihood value. | |
| pwrMESSAGEBOX | Alerts user with pop up message box. | |
| pwrMUNIT | MUNIT | Returns the unit matrix for the specified dimension. |
| pwrNUMBERVALUE | NUMBERVALUE | Converts text to a number, in a locale-independent way. |
| pwrPARSEXML | Parse XML stream using Xpath. | |
| pwrPDURATION | PDURATION | Returns the number of periods required by an investment to reach a specified value. |
| pwrPERMUTATIONA | PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects. |
| pwrPHI | PHI | Returns the value of the density function for a standard normal distribution. |
| pwrRANDFROMRANGE | Return random value from specified range. | |
| pwrRANDFROMSET | Return random value from specified set. | |
| pwrRANDOMNAME | Return random name, optionally by gender. | |
| pwrRANDOMTEXT | Return random text generated of the Lorem Ipsum variety. | |
| pwrREGEXMATCH | Return matching string based on provided regular expression. | |
| pwrREGEXREPLACE | Match using regular expressions and replace with string. | |
| pwrREVERSE | Return the string provided, reversed. | |
| pwrRRI | RRI | Returns an equivalent interest rate for the growth of an investment. |
| pwrSEC | SEC | Returns the secant of an angle. |
| pwrSECH | SECH | Returns the hyperbolic secant of an angle. |
| pwrSENTIMENT | Determine a sentiment rating for the provided text. | |
| pwrSHEET | SHEET | Returns the sheet number of the reference sheet. |
| pwrSHEETS | SHEETS | Returns the number of sheets in a reference. |
| pwrSIMILARITY | Determine the degree of similarity between two strings. | |
| pwrSKEW.P | 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. |
| pwrTRIM | Trims leading, trailing, and multiple spaces within a string. | |
| pwrUNICHAR | UNICHAR | Returns the Unicode character that is referenced by the given numeric value. |
| pwrUNICODE | UNICODE | Returns the number (code point) corresponding to the first character of the text. |
| pwrURLENCODE | URL encode the provided string. | |
| pwrURLESCAPE | URL escape the provided string. | |
| pwrURLPART | Return the requested part of the URL. | |
| pwrURLUNENCODE | Return the provided string with encoded URL values unencoded. | |
| pwrURLUNESCAPE | Return the provided string with escaped URL values unescaped. | |
| pwrVLOOKUP | Return the vertial lookup of a value. The lookup may be fuzzy. | |
| pwrWEBSERVICE | WEBSERVICE | Returns data from a web service on the Internet or Intranet. |
| pwrXOR | XOR | Returns a logical Exclusive Or of all arguments. |
Can you use formulas such as IFERROR, IF nested with pwr formulas? If not, will an update to do this be released in the near future?
Yes, pwr* functions can be nested within built-in functions in Excel. For example, =IF(pwrISBROKENURL(“https://officepowerups.com/brokenurl”),”its broken”, “it’s good”) works as expected.
If you have specific function questions please contact support@officepowerups.com.
Thanks