Two functions in one cell???

S

Skip

I want to get an average of a column of numbers, and then round it
off.,
Can I put two functions in a single cell?
 
A

aidan.heritage

Yes

=round(average(range),2)

or whatever

You can combine many functions, the main thing to remember is you can
only nest brackets up to 7 levels or Excel will refuse to handle it.
 
R

Ron Coderre

You can do what you are asking. Here are 2 approaches:

With values in A1:A10

Calculate the average and round the result:
A11: =ROUND(AVERAGE(A1:A10),2)

Round each number before calculating the average (using an array formula*):
A11: =AVERAGE(ROUND(A1:A10,2))

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
H

Harlan Grove

Ron Coderre wrote...
You can do what you are asking. Here are 2 approaches:

With values in A1:A10

Calculate the average and round the result:
A11: =ROUND(AVERAGE(A1:A10),2)
OK.

Round each number before calculating the average (using an array formula*):
A11: =AVERAGE(ROUND(A1:A10,2))
Click to expand...
....

Not OK. The average of the rounded values won't necessarily be rounded
to 2 decimal places, and it'll produce noticeable roundoff error more
often.
 
Top