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.