[fa icon="long-arrow-left"] Back to all posts
[fa icon="pencil'] Posted by Lewan Solutions [fa icon="calendar"] 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.
Topics: Microsoft
Get even more great content, photos, event info and industry news.
We manage your printing and IT services so you can manage your business. Lewan Technology is a business technology and managed service provider serving Colorado, Wyoming, New Mexico and beyond. As a Xerox company, you can depend on our 45+ years of providing local solutions, service and support, backed by the trusted Xerox name.
[fa icon="phone"] 303.759.5440
[fa icon="home"] Our HQ:
8530 Concord Center Dr #400
Englewood, Colorado 80112
