I needed to round up a number in Excel to the nearest whole number. I found this helpful article that discusses rounding numbers:
But I also needed to round up the number, which was generated by a formula. So here’s the formula that worked:
This formula will round up the result of the SUM calculation.
The ,0 following the SUM calculation is part of the ROUNDUP formula.