• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MKDEC Function
  • MKINT Function
  • MOD Function
  • POS Function
  • PV Function
  • R Function
  • RATIO Function
  • RC Function
  • RCNV Function
  • RCR Function
  • RCTOTAL Function
  • ROUND Function
  • ROWCOUNT Function
  • RR Function
  • RRTOTAL Function
  • STDDEV Function
  • SUM Function
  • TOTAL Function

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

• Mathematical and Financial Functions