Formula Playground
Copy base
Report abuse
Views
Autonumber
Formula Reference
1
1
ABS()
2
2
SUM()
3
3
MIN()
4
4
MAX()
5
5
CEILING()
6
6
FLOOR()
7
7
ROUND()
8
8
ROUNDDOWN()
9
9
ROUNDUP()
10
10
MOD()
11
11
ODD()
12
12
EVEN()
13
13
INT()
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, ....])
Description (from Formula Reference)

Returns the absolute value.

Numeric functions
-10.0

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

Numeric functions
10.0

Returns the smallest of the given numbers.

Numeric functions
10.0

Returns the largest of the given numbers.

Numeric functions
10.0

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
10.5

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
17.8

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
135.8

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
10.7

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

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

Numeric functions
12.0

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

Numeric functions
12.3

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

Numeric functions
12.3

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

Numeric functions
-12.3
25 records
  • All — use the below views to filter between examples!
  • ABS()
  • SUM()
  • MIN()
  • MAX()
  • CEILING()
  • FLOOR()
  • ROUND()
  • ROUNDDOWN()
  • ROUNDUP()
  • MOD()
  • ODD()
  • EVEN()
  • INT()
  • LOG()
  • EXP()
  • POWER()
  • SQRT()
  • VALUE()
  • COUNT()
  • COUNTA()
  • COUNTALL()
Extensions

Alert

Lorem ipsum
Okay