INT function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• COS
• SIN
• TAN
• COT
• ACOS
• ACOT
• ASIN
• ATAN
• ATAN2
• DEGREES
• RADIANS
• PI

Hyperbolic

• COSH
• SINH
• TANH
• COTH
• ACOSH
• ACOTH
• ASINH
• ATANH

Rounding and remainders

• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• INT
• QUOTIENT
• MOD

Logarithm/Powers

• EXP
• POWER
• LOG
• LN
• LOG10

Bessel functions

• BESSELI
• BESSELJ
• BESSELK
• BESSELY

Miscellaneous

• ABS
• COMBIN
• COMBINA
• CONVERT
• CONVERT ADD
• COUNTBLANK
• COUNTIF
• DELTA
• ERF
• ERFC
• FACT
• FACTDOUBLE
• GCD
• GCD ADD
• GESTEP
• ISEVEN
• ISODD
• LCM
• LCM ADD
• MULTINOMIAL
• PRODUCT
• RAND
• RANDBETWEEN
• SERIESSUM
• SIGN
• SQRT
• SQRTPI
• SUBTOTAL
• SUM
• SUMIF
• SUMSQ

< Previous Page

Next Page >

INT

Rounds a number down to the nearest integer.

Syntax:

INT(number)

returns number rounded down to the nearest integer.

Negative numbers round down to the integer below: -1.3 rounds to -2.

Example:

INT(5.7)

returns 5

INT(-1.3)

returns -2.

---

See Also

• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP

• CEILING
• FLOOR
• EVEN
• ODD
• MROUND

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category