Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelINT and TRUNC Function in Excel

# INT and TRUNC Function in Excel

In this post, youâ€™ll get to know about INT and TRUNC function in Microsoft Excel and how to use it in your Excel spreadsheets.

## INT function

The INT function as the name goes rounds off any number to its integer number. As INT function rounds off numbers into integers when it rounds off a negative number it becomes smaller.

It rounds down the numbers.

Syntax

INT(number)

The number is the number to be rounded off.

## TRUNC function

The TRUNC function is similar to the INT function. TRUNC function truncates the number, gives us the integer part thus removing the decimals.

Syntax

TRUNC(number,digits)

The number is the number to be truncated and digits are the number of decimal places to be truncated, itâ€™s optional. By default, the value of digits is zero.

The difference between these functions is that when applied to a negative number INT function always returns the smaller number whereas TRUNC function returns the value according to the digits given.

By now you wouldâ€™ve understood the usage of INT and TRUNC function in Excel.

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