DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Rounding values in a range or column in Excel - Round, RoundUp, RoundDown, Floor, Ceiling, Int, Even, Odd

Excel offers a variety of rounding formulas that allow a user to round a number to just about any approximation. Below is a list and rounding options. But the problem is that you cannot easily apply these formulas to an arbitrary range or table column. DigDB will allow you to do this: Rounding is especially useful when you want a fuzzy match between two tables. For example, if one table's column has a value '2.4', and the other table's column has a value '2.2', and you only care if the two values match in the integer part, then you can round up the 2 columns first, then do the match.

Rounding options

In the rounding command window, use the dropdown box to select how to round. You have the following rounding options:

Round - rounds a number to a specified number of digits.

RoundUp - rounds a number up, away from 0 (zero).

ROUNDUP behaves like ROUND, except that it always rounds a number up.

RoundDown - rounds a number down, toward 0 (zero)

ROUNDUP behaves like ROUND, except that it always rounds a number down.

Ceiling

Floor

Int

Odd

Even

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.