<< Click to Display Table of Contents >> DECIMALS (fractional part of a number) |
Syntax:
DECIMALS(Number)
Description:
Returns the fractional part of the given number (i.e., the digits to the right of the decimal point).
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
Example:
DECIMALS(5.779) returns 0.779
Annotation:
To obtain the places before the decimal point use the TRUNC function.
See also: