Where is the "average" button on Mictosoft Excel? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Stephanie 2/14/2007 4:14 PM PST
  Question
  I can't find the "average" button on Microsoft Excel
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Fred Smith 2/14/2007 4:55 PM PST
  Answer
  It depends on what version you have. In 2002, it's in a drop down list beside
the Sigma.

--
Regards,
Fred


"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
news:778029EE-70B5-41B3-984E-8453E60E5929@microsoft.com...
>I can't find the "average" button on Microsoft Excel


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Stephanie 2/14/2007 5:07 PM PST
   
  Okay... Thanks very much. Now how do you get the average to one decmial?

"Fred Smith" wrote:

> It depends on what version you have. In 2002, it's in a drop down list beside
> the Sigma.
>
> --
> Regards,
> Fred
>
>
> "Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
> news:778029EE-70B5-41B3-984E-8453E60E5929@microsoft.com...
> >I can't find the "average" button on Microsoft Excel
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Ashby 2/14/2007 5:57 PM PST
   
  Either format the cell to "0.0"
or
use something like =ROUND(AVERAGE(A2:A5),1)

"Stephanie" wrote:

> Okay... Thanks very much. Now how do you get the average to one decmial?
>
> "Fred Smith" wrote:
>
> > It depends on what version you have. In 2002, it's in a drop down list beside
> > the Sigma.
> >
> > --
> > Regards,
> > Fred
> >
> >
> > "Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
> > news:778029EE-70B5-41B3-984E-8453E60E5929@microsoft.com...
> > >I can't find the "average" button on Microsoft Excel
> >
> >
> >
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies