FIX
Jump to navigation
Jump to search
Navigation:
The FIX function rounds a numerical value to the next whole number closest to zero.
Syntax
- result = FIX(expression)
Parameters
- expression is any type 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.
Examples
Example 1: Showing the behavior of FIX with positive and negative decimal point values.
PRINT FIX(2.5) PRINT FIX(-2.5)
2 -2
Example 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
See also