Thread: Formulas
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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?