MKINT Function

The MKINT function rounds numeric values to an integer. String values, on the other hand, truncate to an integer by removing the portion after the whole number. All string values should be placed in quotes "" within the brackets.

Syntax

MKINT(expression)

Example 1

MKINT("3.99")

Returns a value of 3 to the cell.

MKINT(3.99)

Returns a value of 4 to the cell.

Example 2

MKINT("10")+MKINT("20")

Returns a value of 30 to the cell.

Example 3

MKINT ("5.6 meters")

Returns a value of 5 to the cell.

Related Topics