In this post you will learn about the INT function in Excel, how to use it in your excel spreadsheets.
The INT function is used to convert a decimal number into its respective integer by rounding off the number towards or away from zero.
The syntax has a single argument
number – This argument holds the number to be converted.
How to use INT Function in Excel?
- The base of the INT function is decimal numbers, to convert the decimal numbers into integers.
- To start, enter the decimal numbers you want to convert and in a new cell enter the INT function syntax.
Highlight the value to insert it in the syntax and press enter to display the answer.
Use the fill handle to apply the function to the rest of the data.
- In the above example when positive decimal numbers are used, they are shortened/round off towards zero.
- It converts the decimal number to the next lower whole number.
- As in the above example when using negative decimal numbers, they are round off away from zero, that is it is converted into the next integer value.
- The syntax returns #VALUE! when a non – numeric value is used.