DECIMALS (fractional part of a number)

<< 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:

TRUNC