## Here are The Useful New Excel 2013 Functions

XOR function | Logical: Returns a logical exclusive OR of all arguments |

IFNA function | Logical: Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |

FORMULATEXT function | Lookup and reference: Returns the formula at the given reference as text |

PDURATION function | Financial: Returns the number of periods required by an investment to reach a specified value |

ALL Function nameS |
Type and description |
---|---|

ACOT function | Math and trigonometry: Returns the arccotangent of a number |

ACOTH function | Math and trigonometry: Returns the hyperbolic arccotangent of a number |

ARABIC function | Math and trigonometry: Converts a Roman number to Arabic, as a number |

BASE function | Math and trigonometry: Converts a number into a text representation with the given radix (base) |

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

BITAND function | Engineering: Returns a ‘Bitwise And’ of two numbers |

BITLSHIFT function | Engineering: Returns a value number shifted left by shift_amount bits |

BITOR function | Engineering: Returns a bitwise OR of 2 numbers |

BITRSHIFT function | Engineering: Returns a value number shifted right by shift_amount bits |

BITXOR function | Engineering: Returns a bitwise ‘Exclusive Or’ of two numbers |

CEILING.MATH function | Math and trigonometry: Rounds a number up, to the nearest integer or to the nearest multiple of significance |

COMBINA function | Math and trigonometry: Returns the number of combinations with repetitions for a given number of items |

COT function | Math and trigonometry: Returns the hyperbolic cosine of a number |

COTH function | Math and trigonometry: Returns the cotangent of an angle |

CSC function | Math and trigonometry: Returns the cosecant of an angle |

CSCH function | Math and trigonometry: Returns the hyperbolic cosecant of an angle |

DAYS function | Date and time: Returns the number of days between two dates |

DECIMAL function | Math and trigonometry: Converts a text representation of a number in a given base into a decimal number |

ENCODEURL function | Web: Returns a URL-encoded string |

FILTERXML function | Web: Returns specific data from the XML content by using the specified XPath |

FLOOR.MATH function | Math and trigonometry: Rounds a number down, to the nearest integer or to the nearest multiple of significance |

FORMULATEXT function | Lookup and reference: Returns the formula at the given reference as text |

GAMMA function | Statistical: Returns the Gamma function value |

GAUSS function | Statistical: Returns 0.5 less than the standard normal cumulative distribution |

IFNA function | Logical: Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |

IMCOSH function | Engineering: Returns the hyperbolic cosine of a complex number |

IMCOT function | Engineering: Returns the cotangent of a complex number |

IMCSC function | Engineering: Returns the cosecant of a complex number |

IMCSCH function | Engineering: Returns the hyperbolic cosecant of a complex number |

IMSEC function | Engineering: Returns the secant of a complex number |

IMSECH function | Engineering: Returns the hyperbolic secant of a complex number |

IMSINH function | Engineering: Returns the hyperbolic sine of a complex number |

IMTAN function | Engineering: Returns the tangent of a complex number |

ISFORMULA function | Information: Returns TRUE if there is a reference to a cell that contains a formula |

ISOWEEKNUM function | Date and time: Returns the number of the ISO week number of the year for a given date |

MUNIT function | Math and trigonometry: Returns the unit matrix or the specified dimension |

NUMBERVALUE function | Text: Converts text to number in a locale-independent manner |

PDURATION function | Financial: Returns the number of periods required by an investment to reach a specified value |

PERMUTATIONA function | Statistical: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |

PHI function | Statistical: Returns the value of the density function for a standard normal distribution |

RRI function | Financial: Returns an equivalent interest rate for the growth of an investment |

SEC function | Math and trigonometry: Returns the secant of an angle |

SECH function | Math and trigonometry: Returns the hyperbolic secant of an angle |

SHEET function | Information: Returns the sheet number of the referenced sheet |

SHEETS function | Information: Returns the number of sheets in a reference |

SKEW.P function | Statistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |

UNICHAR function | Text: Returns the Unicode character that is references by the given numeric value |

UNICODE function | Text: Returns the number (code point) that corresponds to the first character of the text |

WEBSERVICE function | Web: Returns data from a web service. |

XOR function | Logical: Returns a logical exclusive OR of all arguments |