249
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:
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
2
4 8723 10
⋅
×
.
MANT(487.23) = 4.8723
XPON(487.23) = 2
Change
0 0005087
⋅
into scientific notation to get
4
5 087 10
−
⋅
×
.
MANT(0.0005087) = 5.087
XPON(0.0005087) = -4
See also:
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: