Spreadsheet: Rounding and Averaging

[damunzy]

I am using Google Docs and I am taking some monthly statistics from bls.gov and averaging them out to an annual statistic like so:

=AVERAGE(128298,128298,128891,129143,129464,129412,129822,130010,130019,130179,130653,130679)

Which leads to the following answer: 129572.333333333

I would like to have the cell round to the nearest 1s to get the following answer: 129572

How would I do this? I tried wrapping the AVERAGE in ROUND like so: =ROUND(AVERAGE(stuff,stuff)) but that was a go preceded by a no.

Thanks in advance!

 

[Mise]

If it's like Excel then you need to specify the number of decimal places in the ROUND function. You were correct to wrap AVERAGE in ROUND, you just need to add a second argument to the ROUND function specifying the number of decimal places:

=ROUND(AVERAGE(stuff,stuff),2) for 2dp
=ROUND(AVERAGE(stuff,stuff),0) for whole numbers
=ROUND(AVERAGE(stuff,stuff),-1000) for nearest thousand, etc.

 

[damunzy]

Awesome! It was the ,0 I was missing to tell it the decimal places. Thanks a bijillion internet dollars.