Math Functions¶

Aggregation¶

Function	Syntax	Example	Description
SUM	`SUM(number1, ...)`	`=SUM(A1:A10)`	Adds all numbers
AVERAGE	`AVERAGE(number1, ...)`	`=AVERAGE(B1:B5)`	Arithmetic mean
MIN	`MIN(number1, ...)`	`=MIN(A1:A10)`	Smallest value
MAX	`MAX(number1, ...)`	`=MAX(A1:A10)`	Largest value
COUNT	`COUNT(value1, ...)`	`=COUNT(A1:A10)`	Counts numeric values
PRODUCT	`PRODUCT(number1, ...)`	`=PRODUCT(A1:A3)`	Multiplies all numbers
SUMPRODUCT	`SUMPRODUCT(array1, array2)`	`=SUMPRODUCT(A1:A3, B1:B3)`	Sum of element-wise products

Function	Syntax	Example	Result
ROUND	`ROUND(number, digits)`	`=ROUND(3.456, 2)`	3.46
ROUNDUP	`ROUNDUP(number, digits)`	`=ROUNDUP(3.421, 2)`	3.43
ROUNDDOWN	`ROUNDDOWN(number, digits)`	`=ROUNDDOWN(3.789, 2)`	3.78
CEILING	`CEILING(number, significance)`	`=CEILING(4.2, 1)`	5
FLOOR	`FLOOR(number, significance)`	`=FLOOR(4.8, 1)`	4
INT	`INT(number)`	`=INT(3.9)`	3
TRUNC	`TRUNC(number, [digits])`	`=TRUNC(3.456, 1)`	3.4

Function	Syntax	Example	Result
ABS	`ABS(number)`	`=ABS(-5)`	5
MOD	`MOD(number, divisor)`	`=MOD(10, 3)`	1
POWER	`POWER(base, exponent)`	`=POWER(2, 3)`	8
SQRT	`SQRT(number)`	`=SQRT(16)`	4
SIGN	`SIGN(number)`	`=SIGN(-8)`	-1
FACT	`FACT(number)`	`=FACT(5)`	120
GCD	`GCD(number1, number2)`	`=GCD(12, 8)`	4
LCM	`LCM(number1, number2)`	`=LCM(4, 6)`	12

Function	Syntax	Example	Result
LN	`LN(number)`	`=LN(2.718)`	~1
LOG	`LOG(number, [base])`	`=LOG(100, 10)`	2
LOG10	`LOG10(number)`	`=LOG10(1000)`	3
EXP	`EXP(number)`	`=EXP(1)`	~2.718

Function	Syntax	Example	Result
COMBIN	`COMBIN(n, k)`	`=COMBIN(5, 2)`	10
PERMUT	`PERMUT(n, k)`	`=PERMUT(5, 2)`	20

Function	Syntax	Example	Description
SIN	`SIN(angle)`	`=SIN(PI()/2)`	Sine (radians)
COS	`COS(angle)`	`=COS(0)`	Cosine (radians)
TAN	`TAN(angle)`	`=TAN(PI()/4)`	Tangent (radians)
ASIN	`ASIN(number)`	`=ASIN(1)`	Arc sine
ACOS	`ACOS(number)`	`=ACOS(0)`	Arc cosine
ATAN	`ATAN(number)`	`=ATAN(1)`	Arc tangent
ATAN2	`ATAN2(x, y)`	`=ATAN2(1, 1)`	Arc tangent of x/y
DEGREES	`DEGREES(radians)`	`=DEGREES(PI())`	180
RADIANS	`RADIANS(degrees)`	`=RADIANS(180)`	~3.14159
PI	`PI()`	`=PI()`	~3.14159

Function	Syntax	Example	Description
RAND	`RAND()`	`=RAND()`	Random number between 0 and 1
RANDBETWEEN	`RANDBETWEEN(low, high)`	`=RANDBETWEEN(1, 100)`	Random integer in range