Returns the absolute value.
Sum together the numbers. Equivalent to number1 + number2 + ...
Returns the smallest of the given numbers.
Returns the largest of the given numbers.
Returns the nearest integer multiple of significance that is greater than or equal to the value. If no significance is provided, a significance of 1 is assumed.
Rounds the value to the number of decimal places given by "precision." (Specifically, ROUND will round to the nearest integer at the specified precision, with ties broken by rounding half up toward positive infinity.)
Rounds the value to the number of decimal places given by "precision," always rounding down, i.e., toward zero. (You must give a value for the precision or the function will not work.)
Rounds the value to the number of decimal places given by "precision," always rounding up, i.e., away from zero. (You must give a value for the precision or the function will not work.)
Returns the remainder after dividing the first argument by the second.
Rounds positive value up the the nearest odd number and negative value down to the nearest odd number.
Returns the smallest even integer that is greater than or equal to the specified value.
Returns the greatest integer that is less than or equal to the specified value.
Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.
Computes Euler's number (e) to the specified power.
Computes the specified base to the specified power.
Returns the square root of a nonnegative number.
Converts the text string to a number. Some exceptions apply—if the string contains certain mathematical operators(-,%) the result may not return as expected. In these scenarios we recommend using a combination of VALUE and REGEX_REPLACE to remove non-digit values from the string:
VALUE(REGEX_REPLACE(YOURSTRING, "\\D", ""))
Count the number of numeric items.
Count the number of non-empty values. This function counts both numeric and text values.
Count the number of all elements including text and blanks.
Multiply two values
Add together two values
Subtract two values
Divide two values