Two functions in one cell???
 

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?

Two functions in one cell???
 

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.

Two functions in one cell???
 

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


"Skip" wrote:

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?

Two functions in one cell???
 

Sure does, thanks.
Skip

Two functions in one cell???
 

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))
....

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.