average rounding to 3 decimal places

[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

 

[Bernie Deitrick]

Chad,

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

HTH,
Bernie
MS Excel MVP

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.