Around and Around: ROUND Options in Excel


Sometimes we like decimals, sometimes we just want the rounded integer, and sometimes we want decimals rounded down or rounded up.  Fickle bunch, aren't we?

Gladly, Excel makes it easy to turn decimals into whatever rounded integers we need with the ROUND, ROUNDUP, and ROUNDDOWN formulas.  The only thing tricky thing to be aware of is that the formula asks for the number of decimal places we want included.  If we want strictly integers, we provide zero for this term.

=ROUND(N7,0)

ROUNDUP and ROUNDDOWN take the same inputs, but give a different result that either strips the decimal (ROUNDDOWN) or rounds up to the next highest integer (ROUNDUP).

Need additional help with ROUND, ROUNDUP, or ROUNDDOWN?  Reach out today via live chat, email, or phone and our team would be happy to get your issue solved in minute or do your whole project for you!