Returns the integer part of a number.

Syntax

Fix ( numExpr )

Elements

numExpr

Any numeric expression.

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).

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

Example
See Also

LotusScript Language Reference: E through H
CInt function
CLng function
Fraction function
Int function
Integer data type
Round function

Glossary