FIX

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

• _CEIL
• INT, CINT
• CLNG, _ROUND
• MOD, Integer Division
• Normal division

---

Navigation: Main Page with Articles and Tutorials Keyword Reference - Alphabetical Keyword Reference - By usage Report a broken link