ExcelBanter - excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/243988-excel-2003-a.html)

dannman12

excel 2003

How can I do an average and round in the same cell?

excel 2003

do you mean
=(ROUNDUP(AVERAGE(10.5,20.4,30.6),0))

where 10.5, 20.4, 30.6 are the numbers for which you want to find the
avarage and round it up?

-kc
*click YES if this helps

"dannman12" wrote:

How can I do an average and round in the same cell?

All times are GMT +1. The time now is 05:25 AM.