Skip to main content

Formulas for numbers

Our built-in formulas that operate on numbers:

abs​

This formula gives you the absolute value of a number. If the given number is positive or zero, it gives you that number. If it's negative, it gives you the number multiplied by -1.

ln​

ln (number) gives you the natural logarithmic of a number:

sqrt​

This formula gives you the square root of a number:

round​

This formula gives you a rounded version of a number, with the specified number of decimals:

You can also leave out the number of decimals, and it will round to the units:

roundup / ceil​

Rounds the number to the nearest largest integer or number with the given decimal places:

rounddown / floor​

Rounds the number to the nearest smallest integer or number with the given decimal places:

max​

This formula gives you the maximum value of a list or table column:

min​

This formula gives you the minimum value of a list or table column:

sum / total​

This formula gives you the sum of all numbers in a list or a table column:

average / mean / avg​

This formula gives you the mean of a list of numbers:

averageif / meanif / avgif​

This formula gives you the mean of a list of numbers that respect a certain condition:

grow​

This formula compounds an initial value by a specific rate over any sequence or list of values.

stepgrowth​

This formula gives you the increments (or decrements) between values in a sequence or list.

Trignometric​

You must remember our friend Pythagoras; close. Trigonometric formulas relate an angle of a righ-angled triangle with the ratios of two side lengths. By default, they use radians, but you can also play with degrees.

sin / asin​

cos / acos​

tan / atan​

Factorial​

You can compute factorials with the factorial() formula. For example 5!.