INT Function in Excel

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.

Syntax

=INT(number)

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.
How to use INT Function in Excel?

Highlight the value to insert it in the syntax and press enter to display the answer.

How to use INT Function in Excel?

Use the fill handle to apply the function to the rest of the data.

How to use INT Function in Excel?
  • 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.
INT Function in Excel
INT Function in Excel
  • 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.
How to use INT Function in Excel?
  • The syntax returns #VALUE! when a non – numeric value is used.
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.