Microsoft Office Tutorials and References

In Depth Information

**Debugging your formulas**

New functions in Excel 2013

Excel 2013 includes 51 new functions that you can use for

dates, statistics, engineering, and even web data.

Table 6-1 lists all of the functions and describes what they do.

Table 6-1

New functions in Excel 2013

Category

Function Name

Description

Date and Time

DAYS

Calculates the number of days between two dates.

Date and Time

ISOWEEKNUM

Returns the number of the ISO week number of the year for a given date.

Engineering

BITAND

Returns a bitwise AND of two numbers.

Engineering

BITLSHIFT

Returns a numbered generated by shifting the bits in a number to the left by a

specified number of places.

Engineering

BITOR

Returns a bitwise OR of two numbers.

Engineering

BITRSHIFT

Returns a number generated by shifting the bits in a number to the right by a

specified number of places.

Engineering

BITXOR

Returns a bitwise XOR of two numbers.

Engineering

IMCOSH

Returns the hyperbolic cosine of a complex number.

Engineering

IMCOT

Returns the cotangent of a complex number.

Engineering

IMCSC

Returns the cosecant of a complex number.

Engineering

IMCSCH

Returns the hyperbolic cosecant of a complex number.

Engineering

IMSEC

Returns the secant of a complex number.

Engineering

IMSECH

Returns the hyperbolic secant of a complex number.

Engineering

IMSINH

Returns the hyperbolic sine of a complex number.

Engineering

IMTAN

Returns the tangent of a complex number.