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

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.

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

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