How do I use ROUNDUP in Excel?
Use ROUNDUP when you want to round a value up. Enter Number, Number of digits in that order, then add optional arguments when needed.
Excel Function
ROUNDUP
Rounds a number up.
ROUNDUP(number, num_digits)Arguments
number
RequiredSpecify a single cell reference.
num_digits
RequiredEnter a numeric value.
Practice Preview
Use ROUNDUP to round cell D4 (Amount in column D) up to 0 decimal places.
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=ROUNDUP(D4, 0)Result
902
Practice This Function
ROUNDUP FAQ
Where can I practice ROUNDUP?
Use the "Start Function Practice" button to jump straight into ROUNDUP drills.
What arguments does ROUNDUP use?
The main arguments are Number, Number of digits. Enter them in order.