Formula Playground
Copy base
Report abuse
🤖 All Functions and Operators
🚫 Common Errors
✏️Text function examples
❓Logical function examples
#️⃣ Numeric function examples
📆 Date and time function examples
🔎 REGEX function examples
✍️ Record function examples
[] Array function examples
Views
Extensions
Drag to adjust frozen columns
Alert
Lorem ipsum
Okay
14
Loaded
Autonumber
14
Formula Reference
Description (from Formula Reference)
Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.
Type (from Formula Reference)
Numeric functions
Example Number 1
8.0
Example Number 2
2.0
ABS(value)
8.0
SUM(number1, [number2, ...])
10.0
MIN(number1, [number2, ...])
2
MAX(number1, [number2, ...])
8.0
CEILING(value, [significance])
8.0
FLOOR(value, [significance])
8.0
ROUND(value, precision)
8.0
ROUNDDOWN(value, precision)
8.0
ROUNDUP(value, precision)
8.0
MOD(value, divisor)
0.0
ODD(value)
9.0
EVEN(value)
8.0
INT(value)
8.0
LOG(number, [base])
3.0
EXP(power)
2981.0
POWER(base, power)
64.0
SQRT(value)
2.8
VALUE(text)
0.0
Example Text
COUNT(number1, [number2, ....])
2.0
COUNTA(textOrNumber1, [number2, ....])
2.0
COUNTALL(textOrNumber1, [number2, ....])
3.0