Formulas

C

CLR

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

Ron Coderre

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
 
D

Domenic

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

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

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!
 
C

CLR

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
 
R

Rebecca

THANKS BUNCHES!!

CLR said:
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
Click to expand...
 
J

James Silverton

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
 
Top