Mathematical and Trigonometry Functions

Function

Description

ABS

Returns the absolute value of a number

ACOS

Returns the arccosine or the inverse cosine of a number

ACOSH

Returns the inverse hyperbolic cosine of a number

AGGREGATE (2010)

Returns an aggregate in a list or database

ASIN

Returns the arcsine of a number

ASINH

Returns the inverse hyperbolic sine of a number

ATAN

Returns the arctangent of a number

ATAN2

Returns the arctangent based on an x-coordinate or y-coordinate

ATANH

Returns the inverse hyperbolic tangent of a number

CEILING

Rounds a number to the next integer or the multiple of the increments

CEILING.PRECISE (2010)

See CEILING

COMBIN

Returns the number of combinations for the specified number of objects

COS

Returns the cosine of a number ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.