FIX

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)

Example 1: 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

See Also

• _CEIL
• INT, CINT
• CLNG, _ROUND
• MOD, []()
• /