WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » ROUNDUP Function in Excel

ROUNDUP Function in Excel

What Does ROUNDUP Function Do in Excel?

ROUNDUP function in excel is an inbuilt function in excel which is used to calculate the rounded value of the number to its highest degree, or in other words it rounds the number away from zero so if the input provided to this function is =ROUNDUP(0.40,1) we will get 0.4 as a result, this function takes two arguments one being the number and another is the number of digits.

Syntax

ROUNDUP Formula

Parameters

As it is clear from the syntax shown above, the ROUNDUP formula has two parameters, which are as follows:

  • Number: The number parameter is a mandatory parameter of the ROUNDUP formula. It defines the floating-point number, which needs to be rounded up.
  • Num_of_digits: This parameter is also mandatory for the ROUNDUP ROUNDUP formula to work. This parameter defines the number of digits you would like to round the provided Number. This parameter can be positive, negative, or zero.
  • If Num_of_digits = 0: It means the Number will be rounded up to the nearest integer number.
  • If Num_of_digits < 0: It means the Number will be rounded up to the nearest 10, 100, 1000, and so on, depending upon the value of Num_of_digits.
  • If Num_of_digits > 0: It means the Number will be rounded up to the number of decimal places defined by the value of Num_of_digits

These conditions will be much clearer with the help of examples explained in the next section.

How to Use ROUNDUP Function in Excel? (with Examples)

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

Example #1

In this example, we will take the value of Num_of_digits parameter is positive, i.e., Num_of_digits >0:

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1

Example #2

In this example, we will take the value of Num_of_digits parameter = 0:

Example 2

Example #3

In this example, we will take the value of Num_of_digits parameter < 0:

Example 3

Things to Remember

  1. The ROUNDUP formula is just like a ROUND function, except it only rounds up the number upward
  2. Both the parameters of the ROUNDUP formula are mandatory and must be integer values in ROUNDUP Function.
  3. The values of the Num_of_digits parameter should be 1 to 9 only.
  4. The ROUNDUP formula was first introduced in EXCEL 2013 and is available in all subsequent versions of Excel.

Recommended Articles

This has been a guide to ROUNDUP Function Excel. Here we discuss the ROUNDUP Formula in excel and how to use the ROUNDUP function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • VBA RoundUp
  • ROUND Formula in Excel
  • ROUNDDOWN Function
  • MROUND in Excel
  • Mixed References in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download ROUNDUP Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More