average rounding to 3 decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula it is

cells A1 through A6: 913, 1437, 690, 879, 1134, 858. Cell A7 returns the sum of the numbers. I need to format cell B7 to return the average of the same numbers, rounding to 3 decimal places

How would I make this function? I have average =AVERAGE(A1:A6

Thank you for your help

Chad
 
Chad,

=ROUND(AVERAGE(A1:A6),3)

HTH,
Bernie
MS Excel MVP

Chad said:
I have a formula it is

cells A1 through A6: 913, 1437, 690, 879, 1134, 858. Cell A7 returns the
Click to expand...
sum of the numbers. I need to format cell B7 to return the average of the
same numbers, rounding to 3 decimal places.
 
Back
Top