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




Custom Search