bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Formulas > Rounding > Rounding to the Nearest Half Dollar

Rounding to the Nearest Half Dollar

Summary: 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. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

When working with financial data, one common need is to round amounts to some specific point. For instance, you may need to round amounts to the nearest half dollar. The traditional way to perform such a rounding task is to use the ROUND function, with a formula like this:

=ROUND(E27/0.5,0)*0.5

The formula divides the value in E27 by 0.5 (half a dollar), and then rounds it to zero decimal places. The value is then multiplied by 0.5 to get it back to the form you need. If you prefer to not multiply and divide by decimal amounts, you can accomplish the same task in this manner:

=ROUND(E27*2,0)/2

Perhaps an even better approach is to use the MROUND function. This function will round a value to any multiple you specify. In this case, if you want to round the value in E27 to the nearest half dollar, you would use this formula:

=MROUND(E27,0.5)

The MROUND function is part of the Analysis ToolPak. If the function doesn't work for you, you'll need to make sure it is available by choosing Tools | Add-Ins. (If you are using Excel 2007, click the Office button and then click Excel Options. Click Add-ins at the left side of the screen, make sure Excel Add-Ins is selected in the drop-down list at the bottom of the screen, and then click Go.)

Tip #2620 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.
 
Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)