# How to use the ROUNDUP function?

• Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This post will teach you about what the ROUNDUP function is in Microsoft Excel. It will cover a summary of this function, its formula syntax structure, vital constraints of it usage, and also an example for you to experiment with and see how it works.

## Summary of ROUNDUP Function

The ROUNDUP function is a mathematical function that simply rounds a number up, away from 0 (zero).

## Formula Syntax of ROUNDUP Function

ROUNDUP(number, num_digits)

The ROUNDUP function syntax contains these arguments:

• Number  –  Required. Whichever actual number that you prefer to be rounded up.
• Num_digits  –  Required. The amount of digits to which you seek to round number.

## Constraints of its usage

• ROUNDUP acts similarly to ROUND, however it differs in that it constantly rounds a number up.
• When num_digits exceeds 0 (zero), then number is rounded up to the stated number of decimal places.
• Anytime num_digits is 0, then number is rounded up to the closest integer.
• If num_digits is below 0, then number is rounded up to the left of the decimal point.

## Example

Copy the sample data in the table underneath, and paste it into cell A1 of an unused Excel worksheet. For formulas to indicate results, pick them, press F2, and then press Enter. If you must at any point, you can alter the column widths to gain a complete view of the whole dataset in all its wonder!

## Other Similar Topics

ROUND

MROUND

ROUNDDOWN

EVEN

ODD

Back to Software Bytes – Official Website

Back to Excel Tutorial