Arithmetic Functions

The following section describes each availabe arithmetic function, it's associated syntax and examples of how to use each.

ABS

Takes a number and returns it's absolute value by ignoring it's sign, therefore negative numbers are returned as positive.

Syntax	Where	Result
ABS(n)	n is a number	a number

Example	Result
=ABS(17)	17
=ABS(-24)	24
=ABS(0)	0

DEGREES

Converts a value representing radians into degrees.

Syntax	Where	Result
DEGREES(angle)	angle is a number	a number

Example	Result
DEGREES(2)	65.408440973835

EVEN

Round the supplied value n to the next even number. Rounds away from zero, so up for positive numbers and down for negative numbers.

Syntax	Where	Result
EVEN(n)	n is a number	A number

Example	Result
=EVEN(8)	8
=EVEN(7)	7
=EVEN(-7)	-8

INT

Rounds the supplied value n down.

Syntax	Where	Result
INT(n)	n is a number	number

Example	Result
=INT(37)	37
=INT(37.8)	37

MAX

Returns the maximum value of two supplied numbers.

Syntax	Where	Result
MAX(m,n)	m is a number n is a number	a number

Example	Result
=MAX(14, 19)	19
=MAX(-14, -19)	-14

MIN

Returns the minimum value of two supplied numbers.

Syntax	Where	Result
MIN(m, n)	m is a number n is a number	a number

Example	Result
=MIN(14, 19)	14
=MIN(-14, -19)	-19

MOD

Returns the remainder as a result of dividing m by n. It is not possible to divide by zero.

Syntax	Where	Result
MOD(m, n)	m is a number n is a number	a number

Example	Result
=MOD(124, 10)	4 (124/10 gives 12 with a remainder of 4)
=MOD(124, 0)	Error!

MROUND

Rounds the supplied value n to the nearest multiple of m. n and m must both be positive or both negative, or the result is always zero.

Syntax	Where	Result
MROUND(m, n)	m is a number n is a number	a number

Example	Result
=MROUND(14, 5)	15
=MROUND(16, 5)	15
=MROUND(-14, -15)	-15
=MROUND(-14, 5)	0

ODD

Rounds the supplied value n to the next odd number. Rounds away from zero, so up for positive numbers and down for negative numbers.

Syntax	Where	Result
ODD(n)	n is a number	A number

Example	Result
=ODD(8)	9
=ODD(7.1)	9
=ODD(-7.1)	-9

PI

Returns the value of Pi.

Syntax	Result
PI()	A number

Example	Result
=PI()	3.1415729

POWER

Returns a result of the supplied values m to the power n (m^n).

Syntax	Where	Result
POWER(m, n)	m is a number n is a number	A number

Example	Result
=POWER(3, 3)	27

PRODUCT

Returns the product of the supplied values m and n (m*n).

Syntax	Where	Result
PRODUCT(m, n)	m is a number n is a number	A number

Example	Result
=PRODUCT(3, 4)	12

QUOTIENT

Returns the whole number element from dividing m by n. It is not possible to divide by zero.

Syntax	Where	Result
QUOTIENT(m, n)	m is a number n is a number	A number

Example	Result
=QUOTIENT(124, 10)	12
=QUOTIENT(124, 0)	Error!

RADIANS

Converts the supplied numeric value from degrees to radians.

Syntax	Where	Result
RADIANS(angle)	angle is a number	A number

Example	Result
=RADIANS(180)	3.1415927

ROUND

Rounds n to p decimal places. If p is positive, digits are counted to the right of the decimal point. If p is negative, they count to the left of the point.

Syntax	Where	Result
ROUND(n, p)	n is a number p is a number	A number

Example	Result
=ROUND(1254.258, 2)	1254.26
=ROUND(1254.258, -2)	1300

SIGN

Used to find the sign of n. Result is -1 if n is negative, +1 if n is positive or 0 if n is zero.

Syntax	Where	Result
SIGN(n)	n is a number	A number

Example	Result
=SIGN(48.542)	1
=SIGN(3 - 3)	0
=SIGN(-957.2)	-1

SQRT

Computes the square root of n. Note that negative numbers have no real square root.

Syntax	Where	Result
SQRT(n)	n is a number	A number

Example	Result
=SQRT(9)	3
=SQRT(0)	0
=SQRT(-9)	Error!

TRUNC

Truncates the fractional part from n, leaving a whole number. Rounds towards zero, so positive numbers round down, and negative numbers round up.

Syntax	Where	Result
TRUNC(n)	n is a number	A number

Example	Result
=TRUNC(37)	37
=TRUNC(36.9)	36
=TRUNC(-36.9)	-36