ExcelBanter - Where is the "average" button on Mictosoft Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Where is the "average" button on Mictosoft Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/130757-where-average-button-mictosoft-excel.html)

Stephanie

Where is the "average" button on Mictosoft Excel?

I can't find the "average" button on Microsoft Excel

Fred Smith

Where is the "average" button on Mictosoft Excel?

It depends on what version you have. In 2002, it's in a drop down list beside
the Sigma.

--
Regards,
Fred

"Stephanie" wrote in message
...
I can't find the "average" button on Microsoft Excel

Stephanie

Where is the "average" button on Mictosoft Excel?

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" wrote in message
...
I can't find the "average" button on Microsoft Excel

Ashby

Where is the "average" button on Mictosoft Excel?

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" wrote in message
...
I can't find the "average" button on Microsoft Excel

All times are GMT +1. The time now is 11:48 AM.