EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Maths Function in Excel Excel ROUNDUP Function
 

Excel ROUNDUP Function

Madhuri Thakur
Article byMadhuri Thakur

Updated May 3, 2023

ROUNDUP in Excel

 

 

ROUNDUP in Excel

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

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

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 the ROUND Function and ROUNDUP Function. Both functions round the number, but there is a slight difference between them.

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 that 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 rounded up.
  • Num_digits – The number of digits that 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 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 dataset below and need to round the numbers.

Examples 1

Here, we will apply the ROUND Function and ROUNDUP function to the above data to understand the difference in the workings of both 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 functions.

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

  • The ROUNDUP function rounds the numbers 1-9 up.
  • This function can round to the decimal point’s left or right.
  • If num_digits = 0, a number is rounded to the nearest whole number.
  • If num_digits greater than 0, a number is rounded to the right of the decimal point.
  • If num_digits less than 0, a number is rounded 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

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - 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
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*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?

EDUCBA

Download ROUNDUP Function Excel Template

EDUCBA

डाउनलोड ROUNDUP Function Excel Template

🚀 Limited Time Offer! - ENROLL NOW