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

Returns the absolute value.

2
2
SUM()

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

3
3
MIN()

Returns the smallest of the given numbers.

4
4
MAX()

Returns the largest of the given numbers.

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.

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.

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

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

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

10
10
MOD()

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

11
11
ODD()

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

12
12
EVEN()

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

13
13
INT()

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

Cannot adjust frozen columns; click to learn more or reset
Type (from Formula Reference)
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, ....])
Numeric functions
-10.0
10.0
Numeric functions
10.0
10.0
Numeric functions
10.0
12.0
Numeric functions
10.0
12.0
Numeric functions
10.5
0.3
Numeric functions
17.8
0.1
Numeric functions
135.8
0.1
Numeric functions
10.7
0.1
Numeric functions
10.7
0.1
Numeric functions
12.0
10.0
Numeric functions
12.3
10.0
Numeric functions
12.3
10.0
Numeric functions
-12.3
10.0
25 records
Extensions

Alert

Lorem ipsum
Okay