getting averages to round up

[RJweb]

I have a spread sheet with col's that I want to average their totals, but would like them to be rounded up or down. How is this done, I have been looking through help but didn't find anything, thx for your help.

[jeffreybrown]

Look at the functions...

ROUNDUP
ROUNDDOWN

http://www.excelfunctions.net/Excel-Math-Functions.html

[Jakobshavn]

There are two answers. Say we have data in A1 thru A10 like:

6.755766828
2.263884486
8.6800425
7.218655497
3.532177325
9.111943546
9.103327213
9.997085899
4.255945713
0.207611095

The average of this data is:

=AVERAGE(A1:A10) which displays
6.11264401
To round this up:
=ROUNDUP(AVERAGE(A1:A10),0) which displays 7

However if we want to round up the individual items first and then take the average we would use the array formula:
=AVERAGE(ROUNDUP(A1:A10,0)) which displays 6.7


Array formula must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key.

[Jason Eric]

Hi!
You could also do this... Select the range of cells where you want the data rounded off... right click... and click on format cells from the list.... go to number and select the decimal places you want....

Jason...