software

Is there a formula to round numbers to the nearest quarter?

=MROUND(A1,0.25)If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.quot;Rebeccaquot; wrote:

gt; Is there a formula to round numbers to the nearest quarter?

Try this:

A1: (a number)
B1: =MROUND(A1,0.25)

If the MROUND function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Rebeccaquot; wrote:

gt; Is there a formula to round numbers to the nearest quarter?

How do I go to setup? The formula didn't work. It said quot;NAME?quot;

quot;CLRquot; wrote:

gt; =MROUND(A1,0.25)
gt;
gt;
gt; If this function is not available, run the Setup program to install the
gt; Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
gt; by using the Add-Ins command on the Tools menu.
gt;
gt;
gt; quot;Rebeccaquot; wrote:
gt;
gt; gt; Is there a formula to round numbers to the nearest quarter?

In article gt;,
Rebecca gt; wrote:

gt; How do I go to setup? The formula didn't work. It said quot;NAME?quot;

You'll need to enable the Analysis ToolPak...

Tools gt; Add-Ins gt; and check Analysis ToolPak

Hope this helps!

Try this........

Tools gt; Add-ins gt; check the Analysis ToolPak box gt; ok

If you don't see the Analysis ToolPak option, then that is when you would
need to run Setup from your original install disks..........if you're on a
network at work, then probably your MIS Dept will have to install it for you.

Vaya con Dios,
Chuck, CABGx3

quot;Rebeccaquot; wrote:

gt; How do I go to setup? The formula didn't work. It said quot;NAME?quot;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; =MROUND(A1,0.25)
gt; gt;
gt; gt;
gt; gt; If this function is not available, run the Setup program to install the
gt; gt; Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
gt; gt; by using the Add-Ins command on the Tools menu.
gt; gt;
gt; gt;
gt; gt; quot;Rebeccaquot; wrote:
gt; gt;
gt; gt; gt; Is there a formula to round numbers to the nearest quarter?

=ROUND(4*A1,0)/4

No Add-in needed.

quot;Rebeccaquot; wrote:

gt; Is there a formula to round numbers to the nearest quarter?

THANK YOU SOOOOOOOOOOOO MUCH!!!

quot;Domenicquot; wrote:

gt; In article gt;,
gt; Rebecca gt; wrote:
gt;
gt; gt; How do I go to setup? The formula didn't work. It said quot;NAME?quot;
gt;
gt; You'll need to enable the Analysis ToolPak...
gt;
gt; Tools gt; Add-Ins gt; and check Analysis ToolPak
gt;
gt; Hope this helps!
gt;

THANKS BUNCHES!!

quot;CLRquot; wrote:

gt; Try this........
gt;
gt; Tools gt; Add-ins gt; check the Analysis ToolPak box gt; ok
gt;
gt; If you don't see the Analysis ToolPak option, then that is when you would
gt; need to run Setup from your original install disks..........if you're on a
gt; network at work, then probably your MIS Dept will have to install it for you.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt; quot;Rebeccaquot; wrote:
gt;
gt; gt; How do I go to setup? The formula didn't work. It said quot;NAME?quot;
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; =MROUND(A1,0.25)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; If this function is not available, run the Setup program to install the
gt; gt; gt; Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
gt; gt; gt; by using the Add-Ins command on the Tools menu.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Rebeccaquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there a formula to round numbers to the nearest quarter?



quot;Slothquot; wrote:

gt; =ROUND(4*A1,0)/4
gt;
gt; No Add-in needed.
gt;
gt; quot;Rebeccaquot; wrote:
gt;
gt; gt; Is there a formula to round numbers to the nearest quarter?