Fix function (LotusScript® Language)

Returns the integer part of a number.

Syntax

Fix ( numExpr )

Elements

numExpr

Any numeric expression.

Return value

Fix returns the value of its argument with the fractional part removed. The data type of the return value is determined by the data type of numExpr. The following table shows special cases.

numExpr

Return value

NULL

NULL

Variant containing a string interpretable as a number

Double

Variant containing a date/time value

The date part of the value

Usage

The Fix function rounds toward 0:

  • For a positive argument, Fix returns the nearest integer less than or equal to the argument (if the argument is between 0 and 1, Fix returns 0).
  • For a negative argument, Fix returns the nearest integer larger than or equal to the argument (if the argument is between 0 and -1, Fix returns 0).

The Fix function and the Int function behave differently. The return value from Int is always less than or equal to its argument.

Tip: It is always true that Fix(numExpr) + fraction(numExpr) = numExpr.

Example