Excel Formulas to Get Integer Part of a Number ~ Quick Tricks!!

In the previous post, we have seen how to get the decimal part of the number in Excel. Likewise, here we are going to learn how to get an integer part of a number in Excel. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• Use the below formula to get the integer part of the number in Excel.

=TRUNC(number)

Syntax Explanations:

• TRUNC – In Excel, the TRUNC function helps to return a truncated number of a given value.
• Number – It specifies the input range from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

• First, we will enter the input values in Column B.

• Then, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell.

Wrap-Up:

From this short tutorial, you can get some clarification on how to get the integer part of a number in Excel. Hope you like it. Please share your queries with us. We will assist you. Thank you so much for visiting our site!! Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Also:

• Excel Formulas to Highlight the Multiples of Specific Value ~ Easy Tricks!!
• Excel Formulas to Highlight the Missing Values ~ Easy Tutorial!!