Monday, December 12, 2016

New functions in Excel 2013

New functions in Excel 2013

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Click any function name in the following list to see detailed help about that function.

Function name

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

Top of Page

No comments:

Post a Comment