Rounds the input number down to the largest integer of equal or lesser value.

Usage

Int(number)

number (required) The number to be rounded.

Example

(1) Returns 3.

Int(3.6)

(2) Returns -4.

Int(-3.2)

(3) Returns the Int for each row in the input column.

Int([Cost])

Screen_Shot_2020-11-30_at_4.02.12_PM.png

 

See Also

Floor - Rounds the input number up to the closest multiple of equal or lesser value. Unlike Int, this function supports an additional "factor" parameter.

Ceiling - Rounds the input number up to the closest multiple of equal or greater value.

Round - Rounds the input number to the specified number of digits.