- ABS
The ABS function returns the absolute value of a number.
- ACOSINE
Use the ACOSINE function to calculate the arccosine of a value.
- ASIN
Use the ASIN function to calculate the arcsine of a value.
- ATAN
The ATAN function calculates the arctangent of a value.
- ATAN2
The ATAN2 function calculates the arctangent of y,x.
- COSINE
The COSINE function calculates the cosine of a value.
- COSINEH
The COSINEH function calculates the hyperbolic cosine of a value.
- COUNT
You can use the COUNT function to return an integer representing the number of valid input or output objects in a series.
- COUNTABS
You can use COUNTABS to count the input or output objects in a series, regardless of the validity of the object.
- EXP
The EXP function calculates the exponential of a value.
- FACTORIAL
The FACTORIAL function calculates the factorial of a value.
- FROMBASETEN
You can use FROMBASETEN when you need to convert numbers to a base other than 10.
- INT
You can use the INT function when you need only the integer portion of a number.
- LOG
The LOG function calculates the logarithms of a value.
- LOG10
The LOG10 function calculates the logarithms for base 10 of a value.
- MAX
The MAX function returns the maximum value from a series of number, date, time, or text values.
- MIN
Use MIN when you need the minimum value from a series of number, date, time, or text values.
- MOD
Use MOD when you need the modulus of an integer and a number.
- POWER
The POWER function calculates x raised to the power of y.
- RAND
The RAND function returns a pseudorandom number.
- ROUND
The ROUND function rounds a number to a specified number of decimal places.
- SEED
The SEED function primes the RAND and RANDDATA functions so they produce repeated results.
- SIN
The SIN function calculates the sine of a value.
- SINH
The SINH function calculates the hyperbolic sine of a value.
- SQRT
The SQRT function returns the square root of a number.
- SUM
The SUM function calculates the sum of a series of numbers.
- TAN
The TAN function calculates the tangent of a value.
- TANH
The TANH function calculates the hyperbolic tangent of a value.
- TOBASETEN
The TOBASETEN function converts a text item that can be interpreted as a number, using positional notation of the base specified, to a base 10 number.
- TRUNCATE
The TRUNCATE function removes decimal places from a number, leaving a specified number of decimal places.