A Faster Way To Round A Number

BY STANLEY ZAROWIN

Q. When I round financial data to the nearest half-dollar, I use the ROUND function, and while it works fine, a colleague told me the MROUND function is even better. But I can’t find it in Excel. Can you help?

A. My bet is that you haven’t loaded Analysis ToolPak , a collection of powerful functions that comes bundled with Excel but for some reason isn’t automatically loaded when you set up Excel. To load it click on Tools , Templates and Add-Ins . Then place a check next to Analysis ToolPak and you’re in business (see screenshot below).

If you don’t find it under Add-Ins , you have to reload Excel from your original Microsoft Office disk.

When using the ROUND function, you can round to the nearest half-dollar with either of these formulas:

=ROUND(A1/0.5,0)*0.5 or =ROUND(A1*2,0)/2.

The MROUND function uses a shorter formula:

=MROUND(A1,0.5).

SPONSORED REPORT

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

News quiz: Senate health care bill in the spotlight

Reports related to the Republican bill to repeal many provisions of the PPACA, other tax issues, and the giant AICPA ENGAGE Conference offered a diverse reading list for June. See how much you know about recent news with this short quiz.