Average and Round together

[Grd]

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

 

[Duke Carey]

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]

Excellent

Tx

S

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)