ABS
|
Syntax
|
Where
|
Result
|
|---|---|---|
|
ABS(n)
|
n is a number
|
a number
|
Description
The result is the positive version of n, or n if n is already positive
|
Example
|
Result
|
|---|---|
|
=ABS(17)
|
17
|
|
=ABS(-24)
|
24
|
|
=ABS(0)
|
0
|
DEGREES
|
Form
|
Where
|
Result
|
|---|---|---|
|
DEGREES(angle)
|
angle is a number
|
a number
|
Description
Converts angle from radians to degrees
|
Example
|
Result
|
|---|---|
|
DEGREES(2)
|
65.408440973835
|
Even
|
Form
|
Where
|
Result
|
|---|---|---|
|
EVEN(n)
|
n is a number
|
A number
|
Description
Round n to the next even number. Rounds away from zero, so up for positive numbers and down for negative numbers.
|
Example
|
Result
|
|---|---|
|
=EVEN(8)
|
8
|
|
=EVEN(7)
|
7
|
|
=EVEN(-7)
|
-8
|
INT
|
Form
|
Where
|
Result
|
|---|---|---|
|
INT(n)
|
n is a number
|
number
|
Description
Round n down
|
Example
|
Result
|
|---|---|
|
=INT(37)
|
37
|
|
=INT(37.8)
|
37
|
MAX
|
Form
|
Where
|
Result
|
|---|---|---|
|
MAX(m,n)
|
m is a number
n is a number |
a number
|
Description
Chooses the maximum of two numbers
|
Example
|
Result
|
|---|---|
|
=MAX(14, 19)
|
19
|
|
=MAX(-14, -19)
|
-14
|
MIN
|
Form
|
Where
|
Result
|
|---|---|---|
|
MIN(m, n)
|
m is a number
n is a number |
a number
|
Description
Chooses the minimum of two numbers
|
Example
|
Result
|
|---|---|
|
=MIN(14, 19)
|
14
|
|
=MIN(-14, -19)
|
-19
|
MOD
|
Form
|
Where
|
Result
|
|---|---|---|
|
MOD(m, n)
|
m is a number
n is a number |
a number
|
Description
Gives the remainder of dividing m by n. It is not possible to divide by zero
|
Example
|
Result
|
|---|---|
|
=MOD(124, 10)
|
4 (124/10 gives 12 with a remainder of 4)
|
|
=MOD(124, 0)
|
Error!
|
MROUND
|
Form
|
Where
|
Result
|
|---|---|---|
|
MROUND(m, n)
|
m is a number
n is a number |
a number
|
Description
Rounds n to the nearest multiple of m. n and m must both be positive or both negative, or the result is always zero.
|
Example
|
Result
|
|---|---|
|
=MROUND(14, 5)
|
15
|
|
=MROUND(16, 5)
|
15
|
|
=MROUND(-14, -15)
|
-15
|
|
=MROUND(-14, 5)
|
|
ODD
|
Form
|
Where
|
Result
|
|---|---|---|
|
ODD(n)
|
n is a number
|
A number
|
Description
Round n to the next odd number. Rounds away from zero, so up for positive numbers and down for negative numbers.
|
Example
|
Result
|
|---|---|
|
=ODD(8)
|
9
|
|
=ODD(7.1)
|
9
|
|
=ODD(-7.1)
|
-9
|
PI
|
Form
|
Result
|
|---|---|
|
PI()
|
A number
|
Description
The value of π
|
Example
|
Result
|
|---|---|
|
=PI()
|
3.1415729
|
POWER
|
Form
|
Where
|
Result
|
|---|---|---|
|
POWER(m, n)
|
m is a number
n is a number |
A number
|
Description
The result is m^n
|
Example
|
Result
|
|---|---|
|
=POWER(3, 3)
|
27
|
PRODUCT#
|
Form
|
Where
|
Result
|
|---|---|---|
|
PRODUCT(m, n)
|
m is a number
n is a number |
A number
|
Description
The result is m * n.
|
Example
|
Result
|
|---|---|
|
=PRODUCT(3, 4)
|
12
|
QUOTIENT
|
Form
|
Where
|
Result
|
|---|---|---|
|
QUOTIENT(m, n)
|
m is a number
n is a number |
A number
|
Description
Gives the whole number from dividing m by n.
It is not possible to divide by zero.
It is not possible to divide by zero.
|
Example
|
Result
|
|---|---|
|
=QUOTIENT(124, 10)
|
12
|
|
=QUOTIENT(124, 0)
|
Error!
|
RADIANS
|
Form
|
Where
|
Result
|
|---|---|---|
|
RADIANS(angle)
|
angle is a number
|
A number
|
Description
Converts angle from degrees to radians.
|
Example
|
Result
|
|---|---|
|
=RADIANS(180)
|
3.1415927
|
ROUND
|
Form
|
Where
|
Result
|
|---|---|---|
|
ROUND(n, p)
|
n is a number
p is a number |
A number
|
Description
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.
|
Example
|
Result
|
|---|---|
|
=ROUND(1254.258, 2)
|
1254.26
|
|
=ROUND(1254.258, -2)
|
1300
|
SIGN
|
Form
|
Where
|
Result
|
|---|---|---|
|
SIGN(n)
|
n is a number
|
A number
|
Description
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.
|
Example
|
Result
|
|---|---|
|
=SIGN(48.542)
|
1
|
|
=SIGN(3 - 3)
|
0
|
|
=SIGN(-957.2)
|
-1
|
SQRT
|
Form
|
Where
|
Result
|
|---|---|---|
|
SQRT(n)
|
n is a number
|
A number
|
Description
Computes the square root of n. Note that negative numbers have no real square root.
|
Example
|
Result
|
|---|---|
|
=SQRT(9)
|
3
|
|
=SQRT(0)
|
0
|
|
=SQRT(-9)
|
Error!
|
TRUNC
|
Form
|
Where
|
Result
|
|---|---|---|
|
TRUNC(n)
|
n is a number
|
A number
|
Description
Truncates the fractional part from n, leaving a whole number. Rounds towards zero, so positive numbers round down, and negative numbers round up.
|
Example
|
Result
|
|---|---|
|
=TRUNC(37)
|
37
|
|
=TRUNC(36.9)
|
36
|
|
=TRUNC(-36.9)
|
-36
|
When you start typing a function, type the name, then both brackets, and go back to fill in the middle.
This makes is easier to make sure you have the right number of brackets.