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.                                                                                  Search JabSto ::

Custom Search