The FIX function rounds a numerical value to the next whole number closest to zero.
Syntax
result = FIX(expression)
Parameter(s)
- expression is any Data types of literal or variable numerical value or mathematical calculation.
Description
- FIX effectively truncates (removes) the fractional part of expression, returning the integer part.
- This means that FIX rounds down for positive values and up for negative values.
- Use INT to round down negative values. Positive values are rounded down by both.
Example(s)
Showing the behavior of FIX with positive and negative decimal point values.
PRINT FIX(2.5)
PRINT FIX(-2.5)
2
-2
The NORMAL arithmetic method (round half up) can be achieved using the function in the example code below:
PRINT MATHROUND(0.5)
PRINT MATHROUND(1.5)
PRINT MATHROUND(2.5)
PRINT MATHROUND(3.5)
PRINT MATHROUND(4.5)
PRINT MATHROUND(5.5)
FUNCTION MATHROUND(n)
MATHROUND = FIX(n + 0.5 * SGN(n))
END FUNCTION
1
2
3
4
5
6