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.
Like this: Like Loading...
This entry was posted in
Microsoft and tagged microsoft excel by virtualdennis. Bookmark the permalink.
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.
If you want to know more about “Round a Number in Microsoft Excel”, check this link ……..