Spreadsheets - Mathematical Functions

December 2016

Standard Functions

Function Description
ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative
ODD(value) Rounds a number up to the nearest odd integer
MOD(value1; value2) Returns the remainder from division of value1 by value2.
EVEN(value) Rounds a number up to the nearest even integer.
CEILING() Rounds a number to the nearest integer equal to or greater than the value in parenthesis
FLOOR() Rounds a number to the nearest integer equal to or less than the value in parenthesis
PRODUCT(value1; value2; etc.) Returns the product of the multiplication of the values in parenthesis.
SUM(value1; value2; etc.) Returns the sum of the values in parenthesis.
SUMSQ(value1; value2; etc.) Returns the sum of the squares of the arguments.
ROUND(value, number) Rounds the first value to the number of digits indicated by the second number. If the decimal part of the value entered in parenthesis is at least 0.5, the function Math() will round it up to the next whole number.
ROUNDDOWN(value, number) Rounds the first number down to the number of decimal places indicated by the second value.
ROUNDUP(value, number) Rounds the first number up to the number of decimal places indicated by the second value.
MAX(Number1; Number2) Returns the maximum value in the list of arguments.
MIN(Number1; Number2) Returns the minimum value in the list of arguments.
POWER(Value1; Value2) Returns the number Value1 to the power Value2
RAND() The function RAND() returns a pseudo random number between 0 and 1. The value is generated using data from the computer's clock.
ROOT(Value) Returns the square root of the given number
TRUNK(value) Truncates the given number

Logarithms and Exponents

Function Description
EXP(value) Returns the exponent raised to the power of a given number.
FACT(value) Returns the factorial of the number (1 * 2 * ... * value).
LN(value) Returns the natural logarithm of the number.
LOG(value) Returns the logarithm of the number to a specified base.
LOG10(value) Returns the base-10 logarithm of the number.

Trigonometry

Function Description
PI() Returns the value of pi (approximately 3.1415927) accurate to 15 digits
SIN(value) Returns the sine of the given angle (must be written in radians). The returned value is in the interval [-1;1].
ASIN(value) Returns the arcsine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ASIN() returns the value NaN (Not a Number).
SINH(value) Returns the hyperbolic sine of the number.
ASINH(value) Returns the inverse hyperbolic sine of the number.
COS(value) Returns the cosine of the given angle (must be written in radians). The returned value is in the interval [-1;1].
ACOS(value) Returns the arccosine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ACOSH() returns the value NaN (Not a Number).
COSH(value) Returns the hyperbolic cosine of the number (must be written in radians). The returned value is in the interval [-1;1].
ACOSH(value) Returns the inverse hyperbolic cosine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ACOSH() returns the value NaN (Not a Number).
TAN(value) Returns the tangent of the number (must be written in radians).
ATAN(value) Returns the arctangent of the number. The returned value must be in the interval [-1;1]. In other cases, the function ATAN() returns the value NaN (Not a Number).
TANH(value) Returns the hyperbolic tangent of the number.
ATANH(value) Returns the inverse hyperbolic tangent of the number.
DEGREES(value) Converts the number to degrees. The value given must be in radians.
RADIANS(value) Converts the number to radians. The value given must be in degrees.


Related :

This document entitled « Spreadsheets - Mathematical Functions » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.