# Thread: Rounding to a quarter... (Excel 2000 >)

1. ## Rounding to a quarter... (Excel 2000 >)

Ever needed to ROUNDUP or ROUNDDOWN or ROUND to the quarter, or any other interval of choice. Here is a great manipulation on the ROUND function...

Enter a decimaled value in A1and type =ROUND(A1/0.25,0)*0.25 in another cell. You can change the value in the function to round to the interval of choice.

PS: Of stead of searching for the function using the Paste Function Dialog (Fx button), simply type: =FunctionName and press Ctrl + A to activate the pallette automatically.

Cheers

2. ## Re: Rounding to a quarter... (Excel 2000 >)

That will work fine.

The Analysis ToolPak add-in has a dedicated function for this: MROUND. Example:
<code>
=MROUND(A1,0.25)</code>

3. ## Re: Rounding to a quarter... (Excel 2000 >)

Tx...I did not know that....nice reply.

4. ## Re: Rounding to a quarter... (Excel 2000 >)

Hi Rudi,

For workbooks used by others, it's best not to rely on Analysis ToolPak functionality, since the workbooks won't calculate correctly if the user doesn't have the Analysis ToolPak installed.

As for your formula, a shorter form is:
=ROUND(A1*4,0)/4

5. ## Re: Rounding to a quarter... (Excel 2000 >)

Tx for your input. I tried it out and its interesting to note that in your version you need to multiply in the round, and then divide, whereas in the decimaled version, you must divide in the round and then multiply.
Very interesting...
Cheers

6. ## Re: Rounding to a quarter... (Excel 2000 >)

In the end, it's all just a matter of reciprocals.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•