# The Difference Between Truncating and Rounding Numbers

Truncation and rounding are two methods used for approximating numbers but they have different applications and results. Learn more about their differences here.

Truncation is a method of approximating numbers that is simpler than rounding, but it doesn't always give the most accurate result. It is used in computation when division is done with integers and the answer must be an integer. This is done by simply ignoring the digits after the decimal point. In Excel, the difference between rounding and truncating is that when you round down, the formula is %3DROUNDDOWN (num, digits).

When Excel is truncated, it trims part of the entered number and does not perform any rounding. For example, if you enter 345,679 and format the number without decimal points, it cuts off the digits after the decimal point. The entire number stored appears in the formula bar. Rounding and truncation have many subtleties, so for more information, go to Excel Help.

As of this month, all journals of the Association, such as the Journal of Accountancy, The Tax Adviser and FM magazine (due to be published in February) are fully digital. Read more about the change and get tips on how to access new digital flipbook issues. Be the first to know when the JoFa publishes breaking news on taxes, financial reports, auditing or other topics. Select to receive all alerts or only those for the topics that matter most to you.

This quick guide will walk you through the process of adding the Journal of Accountancy as your favorite news source in the Apple News app. Mathematically speaking, rounding calculates the number closest to the input with a specified degree of accuracy. On the other hand, truncating effectively discards any digits after the decimal point and will always round to the nearest integer towards zero. In Java programming, truncation means trimming some digits of a floating or double-type number or some characters from a string from the right. However, if you want to do this on your computer, the algorithm differs slightly depending on whether you are truncating a positive value (greater than or equal to zero) or a negative value (less than zero).

The error “String” or binary data would be truncated indicates that something is being stored in a location that is too short to maintain its full length. Truncation error is defined as the difference between the real value and the truncated value, or 0.00792458 x 108. In databases and computer networks, data truncation occurs when data or a data stream (such as a file) is stored in a location that is too short to maintain its full length. Truncation may involve removing part of something from its beginning, end, top or other part. This trace flag displays the SQL truncation error message: “String or binary data would be truncated in table '%. When used as verbs, rounding down means rounding (a number) to the largest integer that is not greater than it, or to some other lower value, especially an integer of hundreds, thousands, etc., while truncating means shortening (something) by cutting off part of it. The algorithm of subtracting 0.5 from a value and then rounding it (which truncates a positive number) actually has so many uses that Java has been good enough to include a method in your standard library that it will do it for you. In conclusion, both rounding and truncating are methods used for approximating numbers but they have different applications and results.

Rounding calculates the number closest to the input with a specified degree of accuracy while truncating effectively discards any digits after the decimal point.

##### Charlotte Wilson

Friendly travel advocate. Freelance zombie scholar. Extreme web practitioner. Evil coffee buff. Professional beer practitioner.