Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelINT Function in Excel

# 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.

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.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021