Integer [Int]

Return to Complete List of Functions

The Integer function returns the integer portion of a given value. This is also known as "rounding towards zero". See below for a list of similar functions. Parameters ------------------ Value         The value to use in the calculation. This is typically a field in a data series or a calculated value. Function Value ------------------------ The Integer of a number is calculated by removing the fractional part that number. This is primarily used for "rounding" numbers towards zero. Data          Int(Data) --------------------------------   -1.25         -1.00   -1.00         -1.00   -0.75         -0.00   -0.50         -0.00   -0.25         -0.00    0.00          0.00    0.25          0.00    0.50          0.00    0.75          0.00    1.00          1.00    1.25          1.00 Note: This function is based on the C math library definition of the modf function. It differs significantly from the Integer function in Microsoft Excel in its handling of negative numbers. Similar Functions --------------------------- Round          Return the closest integer to a value. Ceiling          Return the first integer that is greater than or equal to a value. ("Rounding up.") Floor             Return the first integer that is less than or equal to a value. ("Rounding down.") Integer          Return the integer portion of a value. ("Rounding towards zero.")