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.