Filter
Top Products
312 Functions and commands
TRUNCATE can also round to a number of significant digits if
places is a negative integer (as shown in the second example
below).
Examples:
TRUNCATE(2.3678,2) returns 2.36
TRUNCATE(0.0036757,–3)
returns 0.00367
Mantissa Mantissa—that is, the significant digits—of value, where
value is a floating-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 10
5 .0 915 . . .
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
K. This opens the computer algebra system.
If you want to return to Home view to make further
calculations, press
H.
Minimum Minimum. The lesser of two values.
MIN(value1,value2)
Example:
MIN(210,25) returns 25