Math and Trig Functions Flashcards
CONVERT(Expression, Datatype)
Converts an expression of one data type to another.
RADIANS(angle)
Converts degrees to radians.
DEGREES(angle)
Converts radians into degrees.
SIGN(number)
Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.
CURRENCY(value)
Evaluates the argument and returns the result as currency data type.
DIVIDE(numerator, denominator[,alternateresult])
Performs division and returns alternate result or BLANK() on division by 0.
QUOTIENT(numerator, denominator)
Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.
MROUND(number, multiple)
Returns a number rounded to the desired multiple.
RAND()
Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The number that is returned changes each time the cell containing this function is recalculated.
RANDBETWEEN(bottom,top)
Returns a random number in the range between two numbers you specify.
EXP(number)
Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.
EVEN(number)
Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate’s capacity.
ODD(number)
Returns number rounded up to the nearest odd integer.
ABS(number)
Returns the absolute value of a number.
ACOS(number)
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.
ASIN(number)
Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2.
ATAN(number)
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.
LOG10(number)
Returns the base-10 logarithm of a number.
COS(number)
Returns the cosine of the given angle.
COT (number)
Returns the cotangent of an angle specified in radians.
FACT(number)
Returns the factorial of a number, equal to the series 123… , ending in the given number.
GCD(number1, [number2], …)
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
COSH(number)
Returns the hyperbolic cosine of a number.
COTH (number)
Returns the hyperbolic cotangent of a hyperbolic angle.
SINH(number)
Returns the hyperbolic sine of a number.
TANH(number)
Returns the hyperbolic tangent of a number.
ACOSH(number)
Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.
ACOTH(number)
Returns the inverse hyperbolic cotangent of a number.
ASINH(number)
Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number.
ATANH(number)
Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number.
LCM(number1, [number2], …)
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
LOG(number,base)
Returns the logarithm of a number to the base you specify.
LN(number)
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
ACOT(number)
Returns the principal value of the arccotangent, or inverse cotangent of a number.
MOD(number, divisor)
Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
POWER(number, power)
Returns the result of a number raised to a power.
SIN(number)
Returns the sine of the given angle.
SQRTPI(number)
Returns the square root of (number * pi).
SQRT(number)
Returns the square root of a number.
TAN(number)
Returns the tangent of the given angle.
PI()
Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
INT(number)
Rounds a number down to the nearest integer.
FLOOR(number, significance)
Rounds a number down, toward zero, to the nearest multiple of significance.
ROUNDDOWN(number, num_digits)
Rounds a number down, toward zero.
ROUND(number, num_digits)
Rounds a number to the specified number of digits.
ROUNDUP(number, num_digits)
Rounds a number up, away from 0 (zero).
CEILING(number, significance)
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
ISO.CEILING(number[, significance])
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
TRUNC(number,num_digits)
Truncates a number to an integer by removing the decimal, or fractional, part of the number.
