S Skip May 10, 2006 #1 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?
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 May 10, 2006 #2 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.
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.
G Guest May 10, 2006 #3 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
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 May 10, 2006 #5 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.
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.
