Thursday, December 26, 2013

Microsoft Excel 2013 New Functions

FUNCTION NAMETYPE AND DESCRIPTION
ACOT functionMath and trigonometry:    Returns the arccotangent of a number
ACOTH functionMath and trigonometry:    Returns the hyperbolic arccotangent of a number
ARABIC functionMath and trigonometry:    Converts a Roman number to Arabic, as a number
BASE functionMath and trigonometry:    Converts a number into a text representation with the given radix (base)
BINOM.DIST.RANGE functionStatistical:    Returns the probability of a trial result using a binomial distribution
BITAND functionEngineering:    Returns a 'Bitwise And' of two numbers
BITLSHIFT functionEngineering:    Returns a value number shifted left by shift_amount bits
BITOR functionEngineering:    Returns a bitwise OR of 2 numbers
BITRSHIFT functionEngineering:    Returns a value number shifted right by shift_amount bits
BITXOR functionEngineering:    Returns a bitwise 'Exclusive Or' of two numbers
CEILING.MATH functionMath and trigonometry:    Rounds a number up, to the nearest integer or to the nearest multiple of significance
COMBINA functionMath and trigonometry:
Returns the number of combinations with repetitions for a given number of items
COT functionMath and trigonometry:    Returns the hyperbolic cosine of a number
COTH functionMath and trigonometry:    Returns the cotangent of an angle
CSC functionMath and trigonometry:    Returns the cosecant of an angle
CSCH functionMath and trigonometry:    Returns the hyperbolic cosecant of an angle
DAYS functionDate and time:    Returns the number of days between two dates
DECIMAL functionMath and trigonometry:    Converts a text representation of a number in a given base into a decimal number
ENCODEURL functionWeb:    Returns a URL-encoded string
FILTERXML functionWeb:    Returns specific data from the XML content by using the specified XPath
FLOOR.MATH functionMath and trigonometry:    Rounds a number down, to the nearest integer or to the nearest multiple of significance
FORMULATEXT functionLookup and reference:    Returns the formula at the given reference as text
GAMMA functionStatistical:    Returns the Gamma function value
GAUSS functionStatistical:    Returns 0.5 less than the standard normal cumulative distribution
IFNA functionLogical:    Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IMCOSH functionEngineering:    Returns the hyperbolic cosine of a complex number
IMCOT functionEngineering:    Returns the cotangent of a complex number
IMCSC functionEngineering:    Returns the cosecant of a complex number
IMCSCH functionEngineering:    Returns the hyperbolic cosecant of a complex number
IMSEC functionEngineering:    Returns the secant of a complex number
IMSECH functionEngineering:    Returns the hyperbolic secant of a complex number
IMSINH functionEngineering:    Returns the hyperbolic sine of a complex number
IMTAN functionEngineering:    Returns the tangent of a complex number
ISFORMULA functionInformation:    Returns TRUE if there is a reference to a cell that contains a formula
ISOWEEKNUM functionDate and time:    Returns the number of the ISO week number of the year for a given date
MUNIT functionMath and trigonometry:    Returns the unit matrix or the specified dimension
NUMBERVALUE functionText:    Converts text to number in a locale-independent manner
PDURATION functionFinancial:    Returns the number of periods required by an investment to reach a specified value
PERMUTATIONA functionStatistical:    Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI functionStatistical:    Returns the value of the density function for a standard normal distribution
RRI functionFinancial:    Returns an equivalent interest rate for the growth of an investment
SEC functionMath and trigonometry:    Returns the secant of an angle
SECH functionMath and trigonometry:    Returns the hyperbolic secant of an angle
SHEET functionInformation:    Returns the sheet number of the referenced sheet
SHEETS functionInformation:    Returns the number of sheets in a reference
SKEW.P functionStatistical:    Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
UNICHAR functionText:    Returns the Unicode character that is references by the given numeric value
UNICODE functionText:    Returns the number (code point) that corresponds to the first character of the text
WEBSERVICE functionWeb:    Returns data from a web service.
XOR functionLogical:    Returns a logical exclusive OR of all arguments