EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel ROUNDUP Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel ROUNDUP Function

By Madhuri ThakurMadhuri Thakur

ROUNDUP in Excel

Excel ROUNDUP Function (Table of Content)

  • ROUNDUP in Excel
  • ROUNDUP Formula in Excel
  • How to Use ROUNDUP Function in Excel?

ROUNDUP in Excel

The roundup function, like any other function, is used for rounding up the number after the decimal, but the important thing about this function is it also allows users to choose after how many digits numbers could be rounded up. We can either retain any number of digits after the decimal or else we can completely round off the selected numbers. We can use positive or negative sign with num_digit to use move decimal right or left side.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Uses of ROUNDUP Function

The ROUNDUP Function rounds a number up to a given number of decimal places. This function rounds a number up, away from zero. You might confuse in between the ROUND Function and ROUNDUP Function. Both functions round the number, but there is a slight difference in between.

The ROUND function can round to the right or left of the decimal point. Whereas the ROUNDUP function always rounds numbers 1-9 up. We will understand this in more detail in the Examples section.

ROUNDUP Function is a built-in function in excel, and it falls under the Math & Trig category function. This function is also known as a Worksheet function in excel. As a worksheet function, this function can be entered as part of a formula in a cell.

ROUNDUP Formula in Excel:

Below is the ROUNDUP Formula:

ROUNDUP Formula in Excel

Where the supplied arguments are:

  • Number – The number that needs to be round up.
  • Num_digits – The number of digits to which the number should be rounded up.

As a worksheet function, the ROUNDUP function can be entered as a part of the formula in excel.

Where is ROUNDUP Function Listed in Excel?

The ROUNDUP function is a built-in function in excel; thus, it can be found under the FORMULAS tab. Please follow the below steps:

  • Click on the FORMULAS tab.

Step 1

  • Select the MATH & Trig options. It will open a drop-down list of functions.

Step 2

  • Select the ROUNDUP Function from the drop-down list.

Step 3

  • It will open a dialog box for Function arguments.

Step 4

  • Enter the value in the Number field that you want to round up.

Step 5

  • Enter the value in Num_digits, the number of digits to which you want to round.

Step 6

How to Use the ROUNDUP Function in Excel?

This ROUNDUP Function is very easy to use. Let us now see how to use the ROUNDUP function in Excel with the help of some examples.

You can download this ROUNDUP Function Excel Template here – ROUNDUP Function Excel Template

Example #1

We have given the below dataset, and we need to round the numbers.

Examples 1

Here, we will apply both the ROUND Function and ROUNDUP function on the above data so that we can understand the difference in workings of both the functions.

Apply the ROUNDUP Formula for the above values:

ROUNDUP Examples 1-2

The Result is:

ROUNDUP Examples 1-3

Drag & drop this formula for the rest values, and the final result is shown below:

ROUNDUP Examples 1-4

Below, we have applied the ROUND function to the same data

ROUNDUP Examples 1-5

The Result is:

ROUNDUP Examples 1-6

Drag & drop this formula for the rest values, and the final result is shown below:

ROUNDUP Examples 1-7

Now below is the comparison between the ROUNDUP function and ROUND function results:

ROUNDUP Examples 1-8

Now it will be much clear the difference between the ROUNDUP and ROUND function.

Example #2

Let’s take the below numbers to round:

Examples 2
Apply the ROUNDUP function to the above data.

ROUNDUP Examples 2-2

The Result is:

ROUNDUP Examples 2-3

Drag & drop this formula for the rest data, and the final result is shown below:

ROUNDUP Examples 2-4

Example #3

Let’s consider another example.

Examples 3

Apply the ROUNDUP function on the above data like the below screenshot:

ROUNDUP Examples 3-2

The Result is:

ROUNDUP Examples 3-3

The final result is shown below:

ROUNDUP Examples 3-4

Things to Remember

  • ROUNDUP function rounds the number 1-9 up.
  • This function can round either to the left or right of the decimal point.
  • If num_digits = 0, a number is rounded up to the nearest whole number.
  • If num_digits greater than 0, a number is rounded up to the right of the decimal point.
  • If num_digits less than 0, a number is rounded up to the left of the decimal point.

Recommended Articles

This has been a guide to ROUNDUP in Excel. Here we discuss the ROUNDUP Formula and how to use the ROUNDUP function along with practical examples and downloadable excel templates. You can also go through our other suggested articles –

  1. PROPER Function in Excel
  2. MROUND in Excel
  3. VBA RoundUp
  4. VBA Round
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download ROUNDUP Function Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ROUNDUP Function Excel Template

EDUCBA

डाउनलोड ROUNDUP Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more