INT

See also A-Z Spreadsheet Function List

Description Rounds the supplied number down to the nearest integer.

Syntax INT(number)

number is any real number.

See Also CEILING , FLOOR , MOD , ROUND , and TRUNC functions

Examples INT(10.99) returns 10

         INT(-10.99) returns -11