
ROUND(7.8676,2) returns 7.87
ROUND(0.0036757,-3) returns 0.00368
Truncate
Truncates value to decimal places. Also accepts complex numbers.
TRUNCATE(value,places)
Examples:
TRUNCATE(2.3678,2) returns 2.36
TRUNCATE(0.0036757,–3) returns 0.00367
Mantissa
Mantissa—that is, the signicant digits—of value, where value is a oating-point number.
MANT(value)
Example:
MANT(21.2E34) returns 2.12
Exponent
Exponent of value. That is, the integer component of the power of 10 that generates value.
XPON(value)
Example:
XPON(123456) returns 5 (since 105.0915... equals 123456)
Arithmetic
Maximum
Maximum. The greater of two values.
MAX(value1,value2)
Example:
MAX(8/3,11/4) returns 2.75
Note that in Home view a non-integer result is given as a decimal fraction. If you want to see the result as a
common fraction, press
. This key cycles through decimal, fraction, and mixed number
representations. Or, if you prefer, press . This opens the computer algebra system. If you want to
return to Home view to make further calculations, press .
Minimum
Minimum. Returns the least of the values given, or the least value of a list.
MIN(value1,value2)
Math menu 353
Komentarze do niniejszej Instrukcji