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: 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
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: 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
To Next Page
Loading...
Need help?
General
