Products, services, and OS functions
may not be available in this country.

INT

The INT function returns the nearest integer that is less than or equal to the number.

INT(num-to-round)

num-to-round: The number value to be rounded.

Examples

=INT(1.49) returns 1, the nearest integer value that is less than or equal to 1.49.

=INT(1.50) returns 1, the nearest integer value that is less than or equal to 1.50.

=INT(1.73456) returns 1, the nearest integer value that is less than or equal to 1.73456.

=INT(-2.2) returns -3, the nearest integer value that is less than (a larger negative value is a lesser value) or equal to -2.2.

See alsoCEILINGEVENFLOORMROUNDODDROUNDROUNDDOWNROUNDUPTRUNC
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.