# Every Useful New Excel 2013 Function

## 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