Autonumber
Formula Reference
Description (from Formula Reference)
Type (from Formula Reference)
1
1
ABS()

Returns the absolute value.

Numeric functions
2
2
SUM()

Sum together the numbers. Equivalent to number1 + number2 + ...

Numeric functions
3
3
MIN()

Returns the smallest of the given numbers.

Numeric functions
4
4
MAX()

Returns the largest of the given numbers.

Numeric functions
5
5
CEILING()

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.

Numeric functions
6
6
FLOOR()

Returns the nearest integer multiple of significance that is less than or equal to the value. If no significance is provided, a significance of 1 is assumed.

Numeric functions
7
7
ROUND()

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.)

Numeric functions
8
8
ROUNDDOWN()

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.)

Numeric functions
9
9
ROUNDUP()

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.)

Numeric functions
10
10
MOD()

Returns the remainder after dividing the first argument by the second.

Numeric functions
11
11
ODD()

Rounds positive value up the the nearest odd number and negative value down to the nearest odd number.

Numeric functions
12
12
EVEN()

Returns the smallest even integer that is greater than or equal to the specified value.

Numeric functions
13
13
INT()

Returns the greatest integer that is less than or equal to the specified value.

Numeric functions
14
14
LOG()

Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.

Numeric functions
15
15
EXP()

Computes Euler's number (e) to the specified power.

Numeric functions
16
16
POWER()

Computes the specified base to the specified power.

Numeric functions
17
17
SQRT()

Returns the square root of a nonnegative number.

Numeric functions
18
18
VALUE()

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", ""))

Numeric functions
19
19
COUNT()

Count the number of numeric items.

Numeric functions
20
20
COUNTA()

Count the number of non-empty values. This function counts both numeric and text values.

Numeric functions
21
21
COUNTALL()

Count the number of all elements including text and blanks.

Numeric functions
22
22
*

Multiply two values

Numeric operators
23
23
+

Add together two values

Numeric operators
24
24
-

Subtract two values

Numeric operators
25
25
/

Divide two values

Numeric operators
Cannot adjust frozen columns; click to learn more or reset
Example Number 1
Example Number 2
ABS(value)
SUM(number1, [number2, ...])
MIN(number1, [number2, ...])
MAX(number1, [number2, ...])
CEILING(value, [significance])
FLOOR(value, [significance])
ROUND(value, precision)
ROUNDDOWN(value, precision)
ROUNDUP(value, precision)
MOD(value, divisor)
ODD(value)
EVEN(value)
INT(value)
LOG(number, [base])
EXP(power)
POWER(base, power)
SQRT(value)
VALUE(text)
Example Text
COUNT(number1, [number2, ....])
COUNTA(textOrNumber1, [number2, ....])
COUNTALL(textOrNumber1, [number2, ....])
-10.0
10.0
10.0
0.0
-10
10.0
-10.0
-10.0
-10.0
-10.0
-10.0
0.0
-11.0
-10.0
-10.0
NaN
0.0
10000000000.0
#ERROR!
0.0
2.0
2.0
3.0
10.0
10.0
10.0
20.0
10
10.0
10.0
10.0
10.0
10.0
10.0
0.0
11.0
10.0
10.0
1.0
22026.5
10000000000.0
3.2
0.0
2.0
2.0
3.0
10.0
12.0
10.0
22.0
10
12.0
10.0
0.0
10.0
10.0
10.0
10.0
11.0
10.0
10.0
0.9
22026.5
1000000000000.0
3.2
0.0
2.0
2.0
3.0
10.0
12.0
10.0
22.0
10
12.0
10.0
0.0
10.0
10.0
10.0
10.0
11.0
10.0
10.0
0.9
22026.5
1000000000000.0
3.2
0.0
2.0
2.0
3.0
10.5
0.3
10.5
10.8
0
10.5
10.5
10.5
10.5
10.0
10.5
0.0
11.0
12.0
10.0
-2.0
36315.5
2.0
3.2
0.0
2.0
2.0
3.0
17.8
0.1
17.8
17.9
0
17.8
17.8
17.8
17.5
17.5
18.3
0.1
19.0
18.0
17.0
-1.3
53757836.0
1.3
4.2
0.0
2.0
2.0
3.0
135.8
0.1
135.8
135.9
0
135.8
135.8
135.8
135.8
135.0
135.8
0.0
137.0
136.0
135.0
-2.1
9.488348824097906e+58
1.6
11.7
0.0
2.0
2.0
3.0
10.7
0.1
10.7
10.8
0
10.7
10.7
10.6
10.3
10.3
11.1
0.1
11.0
12.0
10.0
-1.0
44355.9
1.3
3.3
0.0
2.0
2.0
3.0
10.7
0.1
10.7
10.8
0
10.7
10.7
10.6
10.3
10.3
11.1
0.1
11.0
12.0
10.0
-1.0
44355.9
1.3
3.3
0.0
2.0
2.0
3.0
12.0
10.0
12.0
22.0
10
12.0
20.0
10.0
12.0
12.0
12.0
2.0
13.0
12.0
12.0
1.1
162754.8
61917364224.0
3.5
0.0
2.0
2.0
3.0
12.3
10.0
12.3
22.3
10
12.3
20.0
10.0
12.3
12.3
12.3
2.3
13.0
14.0
12.0
1.1
219696.0
79259460960.5
3.5
0.0
2.0
2.0
3.0
12.3
10.0
12.3
22.3
10
12.3
20.0
10.0
12.3
12.3
12.3
2.3
13.0
14.0
12.0
1.1
219696.0
79259460960.5
3.5
0.0
2.0
2.0
3.0
-12.3
10.0
12.3
-2.3
-12
10.0
-10.0
-20.0
-12.3
-12.3
-12.3
2.3
-13.0
-14.0
-13.0
NaN
0.0
79259460960.5
#ERROR!
0.0
2.0
2.0
3.0
8.0
2.0
8.0
10.0
2
8.0
8.0
8.0
8.0
8.0
8.0
0.0
9.0
8.0
8.0
3.0
2981.0
64.0
2.8
0.0
2.0
2.0
3.0
2.0
10.0
2.0
12.0
2
10.0
10.0
0.0
2.0
2.0
2.0
2.0
3.0
2.0
2.0
0.3
7.4
1024.0
1.4
0.0
2.0
2.0
3.0
10.0
3.0
10.0
13.0
3
10.0
12.0
9.0
10.0
10.0
10.0
1.0
11.0
10.0
10.0
2.1
22026.5
1000.0
3.2
0.0
2.0
2.0
3.0
16.0
10.0
16.0
26.0
10
16.0
20.0
10.0
16.0
16.0
16.0
6.0
17.0
16.0
16.0
1.2
8886110.5
1099511627776.0
4.0
0.0
2.0
2.0
3.0
10.0
10.0
10.0
20.0
10
10.0
10.0
10.0
10.0
10.0
10.0
0.0
11.0
10.0
10.0
1.0
22026.5
10000000000.0
3.2
13395.0
1lov3numb395!
2.0
3.0
3.0
10.0
5.0
10.0
15.0
5
10.0
10.0
10.0
10.0
10.0
10.0
0.0
11.0
10.0
10.0
1.4
22026.5
100000.0
3.2
0.0
apple
2.0
3.0
3.0
10.0
5.0
10.0
15.0
5
10.0
10.0
10.0
10.0
10.0
10.0
0.0
11.0
10.0
10.0
1.4
22026.5
100000.0
3.2
0.0
apple
2.0
3.0
3.0
10.0
10.0
10.0
20.0
10
10.0
10.0
10.0
10.0
10.0
10.0
0.0
11.0
10.0
10.0
1.0
22026.5
10000000000.0
3.2
0.0
2.0
2.0
3.0
NaN
0.0
0
0.0
0.0
NaN
NaN
NaN
NaN
NaN
NaN
#ERROR!
NaN
NaN
#ERROR!
#ERROR!
NaN
0.0
0.0
0.0
3.0
NaN
0.0
0
0.0
0.0
NaN
NaN
NaN
NaN
NaN
NaN
#ERROR!
NaN
NaN
#ERROR!
#ERROR!
NaN
0.0
0.0
0.0
3.0
NaN
0.0
0
0.0
0.0
NaN
NaN
NaN
NaN
NaN
NaN
#ERROR!
NaN
NaN
#ERROR!
#ERROR!
NaN
0.0
0.0
0.0
3.0
NaN
0.0
0
0.0
0.0
NaN
NaN
NaN
NaN
NaN
NaN
#ERROR!
NaN
NaN
#ERROR!
#ERROR!
NaN
0.0
0.0
0.0
3.0
25 records
Extensions

Alert

Lorem ipsum
Okay