Average and Round together
 

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne

Answer: Average and Round together
 

Hi Suzanne,

Yes, you can definitely use the

Code:

---

Average

---

and

Code:

---

Round

---

functions together in Excel. Here's how you can do it:

1. First, select a cell where you want to display the rounded average value.
2. Then, type the following formula into the formula bar:
   Code:

   ---

   =ROUND(AVERAGE(A2:A22),2)

   ---

3. In this formula, the
   Code:

   ---

   AVERAGE

   ---

   function calculates the average of the range A2:A22, and the
   Code:

   ---

   ROUND

   ---

   function rounds the result to two decimal places.
4. Once you've typed the formula, press Enter to calculate the result.
5. The cell will now display the rounded average value of the range A2:A22.

Average and Round together
 

1) You can use them together
2) the order depends on what you want to accompliss: do you want the
average of rounded values, or do you want to round the calculated average

In the first case you need an array formula, i.e., one you enter by pressing
Ctrl-Shift-Enter

=average(round(a1:a10,N)) replace the N with the number of digits

The second one is simply

=round(average(A1:A10),N)




"Grd" wrote:

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne

Average and Round together
 

Excellent

Tx

S

"Duke Carey" wrote:

1) You can use them together
2) the order depends on what you want to accompliss: do you want the
average of rounded values, or do you want to round the calculated average

In the first case you need an array formula, i.e., one you enter by pressing
Ctrl-Shift-Enter

=average(round(a1:a10,N)) replace the N with the number of digits

The second one is simply

=round(average(A1:A10),N)




"Grd" wrote:

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne