ExcelFunctions.net

Search Site:

In Microsoft's release of Excel 2013, several new functions, mainly in the Math, Statistical and Engineering categories, were introduced. The new functions are listed by category below:

Date & Time Functions | |
---|---|

DAYS | Returns the number of days between 2 dates |

ISOWEEKNUM | Returns the ISO week number of the year for a given date |

Engineering Functions | |
---|---|

BITAND | Returns a Bitwise 'And' of two numbers |

BITOR | Returns a Bitwise 'Or' of two numbers |

BITLSHIFT | Returns a number shifted left by a specified number of bits |

BITRSHIFT | Returns a number shifted right by a specified number of 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 |

Financial Functions | |
---|---|

PDURATION | Calculates the number of periods required for an investment to reach a specified value |

RRI | Calculates an equivalent interest rate for the growth of an investment |

Information Functions | |
---|---|

ISFORMULA | Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE |

SHEET | Returns the sheet number relating to a supplied reference |

SHEETS | Returns the number of sheets in a reference |

Logical Functions | |
---|---|

IFNA | Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression |

XOR | Returns a logical Exclusive Or of all arguments |

Lookup Function | |
---|---|

FORMULATEXT | Returns a formula as a string |

Math & Trigonometry Functions | |
---|---|

ARABIC | Converts a Roman numeral to an Arabic numeral |

ACOT | Returns the arccotangent of a number |

ACOTH | Returns the hyperbolic arccotangent of a number |

BASE | Converts a number into a text representation, with the supplied 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 |

COT | Returns the cotangent of an angle |

COTH | Returns the hyperbolic cotangent of an angle |

CSC | Returns the cosecant of an angle |

CSCH | Returns the hyperbolic cosecant of an angle |

DECIMAL | Converts a text representation of a number in a specified 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 for a specified dimension |

SEC | Returns the secant of an angle |

SECH | Returns the hyperbolic secant of an angle |

Statistical Function | |
---|---|

BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution |

GAMMA | Return the gamma function value for a supplied number |

GAUSS | Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean |

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 function for a standard normal distribution, for a supplied number |

SKEW.P | Returns the skewness of a distribution based on a population |

Text Functions | |
---|---|

NUMBERVALUE | Converts text to a number, in a locale-independent way |

UNICHAR | Returns the Unicode character that is referenced by the given numeric value |

UNICODE | Returns the number (code point) corresponding to the first character of a supplied text string |

Web Functions | |
---|---|

ENCODEURL | Returns a URL-encoded string |

FILTERXML | Returns data from XML content, using a specified XPath |

WEBSERVICE | Returns data from a web service on the Internet or Intranet |