Microsoft Excel – Rounding Numbers to Nearest Whole Number

Posted on by

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.

This entry was posted in Microsoft and tagged by virtualdennis. Bookmark the permalink.

About virtualdennis

I have over 18 years helping small to large enterprise businesses nationwide with their enterprise storage, backup and recovery, disaster recovery and system virtualization solutions. He holds numerous storage and virtualization certifications and has personally delivered over 300 complex enterprise solution implementations. He has been privileged to speak at various national events on the topics of datacenter virtualization, end-user virtualization, hyper-converged infrastructure and disaster recovery.

1 thought on “Microsoft Excel – Rounding Numbers to Nearest Whole Number”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s