Topic: Rounding

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Rounding in Results Sometimes the results shown by various calculations can seem downright odd. This tip shows a couple of those calculations and explains why the results aren’t really odd, if you know what Excel is doing. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Rounding Numbers The primary method of rounding values is to use the ROUND function in your formulas. Here’s an introduction to this useful worksheet function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Rounding Religious Wars How to round values half way between two boundaries is apparently a topic of contention in some sectors of the statistical world. This tip discusses the brouhaha and looks at different takes on the issues involved. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Rounding Religious Wars, Take Two How to round values half way between two boundaries is apparently a topic of contention in some sectors of the statistical world. This tip is the second part of a continuing discussion on this issue. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Rounding Time Do you need to round time values to the nearest quarter hour or some other portion of an hour? You can use the MROUND function (part of the Analysis ToolPak) to accomplish the rounding, as demonstrated in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Rounding to Even and Odd Values You can use the EVEN and ODD worksheet functions to round a value to the next highest even or odd value. This can come in handy for some data processing where you must work with such values. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Rounding to the Nearest $50 Excel provides a worksheet function, MROUND, that allows you to round a value to the nearest multiple of a given rounding value. This tip explains how you can use this function to round to the nearest $50, but it also provides other formulas you can use if you don't want to use MROUND. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Rounding To the Nearest Even Integer Do you need your numbers to be rounded to an even integer value? How you accomplish the task depends on the nature of the numbers you are starting with. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Rounding to the Nearest Half Dollar Do you need to round your data to the nearest half dollar? This tip presents several ways (three formulas, to be exact) that you can use to get the desired data change. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Using the MROUND Worksheet Function If you want to round a value to some multiple of a whole number, you’ll want to become familiar with the MROUND function. This tip explains how you can use this function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds