ExcelBanter - How do I round up the result of a sum

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I round up the result of a sum (https://www.excelbanter.com/excel-worksheet-functions/9627-how-do-i-round-up-result-sum.html)

Mikewoodmsw

How do I round up the result of a sum

I want to add several cells, divide the result by the number of cells and
round that number to the nearest whole number.

e.g Round up (SUM E2,F2,G2)/2

Help

Jake Marx

Hi Mikewoodmsw,

This should do what you're looking for:

=CEILING(AVERAGE(E2:G2),1)

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Mikewoodmsw wrote:
I want to add several cells, divide the result by the number of cells
and round that number to the nearest whole number.

e.g Round up (SUM E2,F2,G2)/2

Help

All times are GMT +1. The time now is 12:14 PM.