MATH

Function
Example call
Expected result

ABS

ABS(-4)

4

ACOS

ACOS(-0.5)

2.094395102

ACOSH

ACOSH(10)

2.993222846

ACOT

ACOT(2)

0.463647609

ACOTH

ACOTH(6)

0.168236118

AGGREGATE

AGGREGATE(9, 4, [-5,15], [32,'Hello World!'])

10,32

ARABIC

ARABIC('MCMXII')

1912

ASIN

ASIN(-0.5)

-0.523598776

ASINH

ASINH(-2.5)

-1.647231146

ATAN

ATAN(1)

0.785398163

ATAN2

ATAN2(-1, -1)

-2.35619449

ATANH

ATANH(-0.1)

-0.100335348

BASE

BASE(15, 2, 10)

1111

CEILING

CEILING(-5.5, 2, -1)

-6

CEILINGMATH

CEILINGMATH(-5.5, 2, -1)

-6

CEILINGPRECISE

CEILINGPRECISE(-4.1, -2)

-4

COMBIN

COMBIN(8, 2)

28

COMBINA

COMBINA(4, 3)

20

COS

COS(1)

0.540302306

COSH

COSH(1)

1.543080635

COT

COT(30)

-0.156119952

COTH

COTH(2)

1.037314721

CSC

CSC(15)

1.537780562

CSCH

CSCH(1.5)

0.469642441

DECIMAL

DECIMAL('FF', 16)

255

ERF

ERF(1)

0.842700793

ERFC

ERFC(1)

0.157299207

EVEN

EVEN(-1)

-2

EXP

EXP(1)

2.718281828

FACT

FACT(5)

120

FACTDOUBLE

FACTDOUBLE(7)

105

FLOOR

FLOOR(-3.1)

-4

FLOORMATH

FLOORMATH(-4.1, -2, -1)

-4

FLOORPRECISE

FLOORPRECISE(-3.1, -2)

-4

GCD

GCD(24, 36, 48)

12

INT

INT(-8.9)

-9

ISEVEN

ISEVEN(-2.5)

TRUE

ISOCEILING

ISOCEILING(-4.1, -2)

-4

ISODD

ISODD(-2.5)

FALSE

LCM

LCM(24, 36, 48)

144

LN

LN(86)

4.454347296

LOG

LOG(8, 2)

3

LOG10

LOG10(100000)

5

MOD

MOD(3, -2)

-1

MROUND

MROUND(-10, -3)

-9

MULTINOMIAL

MULTINOMIAL(2, 3, 4)

1260

ODD

ODD(-1.5)

-3

POWER

POWER(5, 2)

25

PRODUCT

PRODUCT(5, 15, 30)

2250

QUOTIENT

QUOTIENT(-10, 3)

-3

RADIANS

RADIANS(180)

3.141592654

RAND

RAND()

[Random real number greater between 0 and 1]

RANDBETWEEN

RANDBETWEEN(-1, 1)

[Random integer between bottom and top]

ROUND

ROUND(626.3, -3)

1000

ROUNDDOWN

ROUNDDOWN(-3.14159, 2)

-3.14

ROUNDUP

ROUNDUP(-3.14159, 2)

-3.15

SEC

SEC(45)

1.903594407

SECH

SECH(45)

5.73E-20

SIGN

SIGN(-0.00001)

-1

SIN

SIN(1)

0.841470985

SINH

SINH(1)

1.175201194

SQRT

SQRT(16)

4

SQRTPI

SQRTPI(2)

2.506628275

SUBTOTAL

SUBTOTAL(9, [-5,15], [32,'Hello World!'])

10,32

SUM

SUM(-5, 15, 32, 'Hello World!')

42

SUMIF

SUMIF([2,4,8,16], '>5')

24

SUMIFS

SUMIFS([2,4,8,16], [1,2,3,4], '>=2', [1,2,4,8], '<=4')

12

SUMPRODUCT

SUMPRODUCT([[1,2],[3,4]], [[1,0],[0,1]])

5

SUMSQ

SUMSQ(3, 4)

25

SUMX2MY2

SUMX2MY2([1,2], [3,4])

-20

SUMX2PY2

SUMX2PY2([1,2], [3,4])

30

SUMXMY2

SUMXMY2([1,2], [3,4])

8

TAN

TAN(1)

1.557407725

TANH

TANH(-2)

-0.96402758

TRUNC

TRUNC(-8.9)

-8