Math/Numeric Functions Flashcards
ABS
returns the absolute value of a number
ACOS
returns the arc cosine of a number
ASIN
returns the arc sine of a number
ATAN
return the arc tangent of a number
ATN2
returns the arc tangent of two numbers
AVG
returns the average value of an expression
CEILING
returns the smallest integer value that is >= a number
COUNT
returns the number of records returned by a select query
COS
returns the cosine of a number
COT
returns the cotangent of a number
DEGREES
converts a value in radians to degrees
EXP
returns e raised to the power of a specified number
FLOOR
returns the largest integer value that is <= to a number
LOG
returns the natural logarithm of a number, or the logarithm of a number to a specified base
LOG10
returns the natural logarithm of a number to base 10
MAX
returns the maximum value in a set of values
MIN
returns the minimum value in a set of values
PI
returns the value of PI
POWER
returns the value of a number raised to the power of another number
RADIANS
converts a degree value into radians
RAND
returns a random number
ROUND
rounds a number to a specified number of decimal places
SIGN
returns the sign of a number
SIN
returns the sine of a number
SQRT
returns the square root of a number
SQUARE
returns the square of a number
SUM
calculates the sum of a set of values
TAN
returns the tangent of a number
