Microsoft Office Tutorials and References

In Depth Information

**Math and Trigonometry Functions**

Returns the position of an item in an array that matches a specified

value and order.

MATCH

Returns a reference to a range that is a specific number of rows

and columns from a cell or range of cells.

OFFSET

Returns the row number based on a reference.

ROW

Returns the number of rows based on a reference or array.

ROWS

Returns a horizontal range of cells as vertical or vice versa.

TRANSPOSE

Looks for a value in the leftmost column of a table and returns a

value from the column number you specify.

VLOOKUP

Math and Trigonometry Functions

ABS

Returns the absolute value of number.

Returns the arccosine of number. The arccosine is the angle

whose cosine is number.

ACOS

Returns the inverse hyperbolic cosine of number.

ACOSH

Returns the arccosine of number.

ASIN

Returns the inverse hyperbolic sine of number.

ASINH

Returns the arctangent of number.

ATAN

Returns the arctangent of the specified x and y coordinates.

ATAN2

Returns the inverse hyperbolic tangent of number.

ATANH

Returns number rounded up, away from zero, to the nearest

multiple of significance.

CEILING

Returns the number of combinations for a given number of items.

COMBIN

Returns the cosine of a given angle.

COS

Returns the hyperbolic cosine of number.

COSH

Counts the number of cells in a specified range that meet the

criteria you specify.

COUNTIF

Converts radians into degrees.

DEGREES

Returns number rounded up to the nearest integer.

EVEN

Returns E raised to the power of number.

EXP

Returns the factorial of number.

FACT

Returns the double factorial of number.

FACTDOUBLE

Rounds number down, toward zero, to the nearest multiple of

significance.

FLOOR

Returns the greatest common divisor of two or more integers.

GCD

Rounds number down to the nearest integer.

INT