Formulas
 

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

Formulas
 

=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.


"Rebecca" wrote:

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

Formulas
 

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-Pro


"Rebecca" wrote:

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

Formulas
 

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

"CLR" wrote:

=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.


"Rebecca" wrote:

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

Formulas
 

In article ,
Rebecca wrote:

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

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

Tools Add-Ins and check Analysis ToolPak

Hope this helps!

Formulas
 

Try this........

Tools Add-ins check the Analysis ToolPak box 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

"Rebecca" wrote:

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

"CLR" wrote:

=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.


"Rebecca" wrote:

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

Formulas
 

=ROUND(4*A1,0)/4

No Add-in needed.

"Rebecca" wrote:

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

Formulas
 

THANK YOU SOOOOOOOOOOOO MUCH!!!

"Domenic" wrote:

In article ,
Rebecca wrote:

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

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

Tools Add-Ins and check Analysis ToolPak

Hope this helps!

Formulas
 

THANKS BUNCHES!!

"CLR" wrote:

Try this........

Tools Add-ins check the Analysis ToolPak box 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

"Rebecca" wrote:

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

"CLR" wrote:

=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.


"Rebecca" wrote:

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

Formulas
 

"Sloth" wrote:

=ROUND(4*A1,0)/4

No Add-in needed.

"Rebecca" wrote:

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

Formulas
 

Hello, Kathy!
You wrote on Sat, 23 Sep 2006 05:11:01 -0700:

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

Oh! These mysterious empty messages!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not