Lewan Technology Blog

Microsoft Excel - Rounding Numbers to Nearest Whole Number

Written by Lewan Solutions | December 30, 2011

I needed to round up a number in Excel to the nearest whole number. I found this helpful article that discusses rounding numbers:
http://www.ozgrid.com/Excel/excel-rounding.htm

But I also needed to round up the number, which was generated by a formula. So here's the formula that worked:
=ROUNDUP(SUM(Input!D65:F65)/100,0)
This formula will round up the result of the SUM calculation.
The ,0 following the SUM calculation is part of the ROUNDUP formula.