If you leave this argument blank, Excel will truncate everything after the decimal point. The INT function, however, both gets rid of decimal places and rounds. Click into B2 and type the following formula:.
As you probably expected, we get a similar result. All the numbers behind the decimal point have been removed. The result, 3. If you want to see When you use a negative number as the second argument, Excel truncates the numbers before the decimal point.
The biggest advantage to using TRUNC is that you retain all of the information you started with—because the new number gets placed in a new cell. The Excel INT function returns the integer part of a decimal number by rounding down to the integer.
Note that negative numbers become more negative. For example, while INT The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers away from zero, so positive numbers become larger and negative numbers become smaller i.
The EVEN function always rounds numbers away from zero, so positive numbers become larger and negative numbers become smaller i. Skip to main content. Truncate a number to a given precision. Return value. Excel Usage notes. TRUNC formula examples. Data validation whole percentage only. In this formula Best iPad Mini Cases. Best Gifts for Cutting the Cord. Best Bluetooth Speakers. Awesome PC Accessories.
Best Linux Laptops. Best Gaming Monitors. Best iPads. Best iPhones. Best External Hard Drives. Browse All News Articles. Smart TVs Ads. Team Comes to Workplace by Meta. Block People Spotify.
Verizon Selling PS5. Windows 11 SE Explained. Windows 11 SE. Microsoft Default Browser Firefox. Google's New Pet Art. Robinhood Hack Find Downloaded Files on an iPhone. Use Your iPhone as a Webcam. Hide Private Photos on iPhone.
Take Screenshot by Tapping Back of iPhone. Should You Upgrade to Windows 11? Browse All Windows Articles. Copy and Paste Between Android and Windows.
0コメント