⋅
⋅
⋅
⋅
INT(<num>)
This function is related to the
FLOOR
and
CEILING
functions. Unlike
those two, which consistently move down or up respectively, the
INT
function simply drops the fractional part of the number.
Eg.
INT(3.786)
= 3
INT(-5.84)
= -5
See also:
FLOOR
,
CEILING
,
ROUND
,
TRUNCATE
,
FRAC
MANT(<num>)
This function returns the mantissa (numerical part) of the number you feed
it when transformed into scientific notation. It would be used with the
XPON
function, which returns the power part of the number in scientific
notation.
Eg.
Change
487 23
into scientific notation to get
4 8723
×
10
2
.
MANT(487.23)
= 4.8723
XPON(487.23)
= 2
4
Change
0 0005087
into scientific notation to get
5 087
×
10
−
.
MANT(0.0005087)
= 5.087
XPON(0.0005087)
= -4
See also:
XPON
MAX(num1,num2)
This function returns the larger of two values entered. This is not needed
in your normal calculations, since you could just look at the numbers, but
a programmer will be writing a program which deals with numbers not
known in advance.
Eg.
MAX(3,5)
= 5
See also:
MIN
173