Filter
Top Products
314 Functions and commands
ROUND can also round to a number of significant digits if
places is a negative integer (as shown in the second example
below).
Examples:
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)
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 c.. This key cycles through decimal,
fraction, and mixed number representations. Or, if you prefer,