HomeApplicationOffice information

ROUNDUP function in Excel - Usage and examples

Today, the Software Tips will guide you how to use the ROUNDUP function to round numbers (rounding up) in excel.

ROUNDUP function in Excel - Usage and examples Picture 1

ROUNDUP function structure

Function syntax: = ROUNDUP (Number, Num_digits).

Inside:

 + ROUNDUP: is the function name.

 + Number: is the number to be rounded up.

 + Num_digits: is the number of digits after the comma you want to round.

For example:

Note: if you do not enter the value of Num_digits then Excel will understand the value of Num_digits = 0.

To understand Num_digits better, please refer to the picture below:

ROUNDUP function in Excel - Usage and examples Picture 2

So that:

 + If num_digits> 0, the number is rounded up to the specified number of decimal places.

+ If num_digits = 0, the number is rounded to the nearest integer.

+ If num_digits <0, the number is rounded up to the left of the decimal point.

Compare ROUNDUP, ROUND, INT functions

Besides the ROUND UP function, Excel also provides its users with a number of rounding functions and uses the following functions:

  1. ROUND (number, num_digits) function: The round function works like the roundup function. However, with a value above or equal to 5, the function will round up and a value below 5 will round down like math.
  2. ROUNDDOWN (number, num_digits) function: The rounddown function works the opposite of the round up function, which rounds down regardless of the subsequent value.
  3. INT (number) function: INT function Rounds a number down to the nearest integer.

Hope you understand how to use the ROUNDUP function that the Software Tips mentioned above.

Good luck! ^^

4 ★ | 1 Vote

You should read it

May be interested

  • DSUM function in Excel, how to use DSUM function and examplesDSUM function in Excel, how to use DSUM function and examples
    dsum function in excel, how to use dsum function and examples. the dsum function in excel is a fairly common function with a fairly simple usage. but if you do not know how to use the dsum function, you can refer to the following article to understand h
  • How to use the MAXA function in Excel, detailed examplesHow to use the MAXA function in Excel, detailed examples
    the maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
  • How to round numbers using the Roundup function in ExcelHow to round numbers using the Roundup function in Excel
    in excel, rounding numbers helps optimize calculations and display data more clearly. the roundup function is one of the important tools that helps round numbers up automatically. compared to the round function, this function always rounds up instead of rounding normally.
  • RANK function - Rank function in Excel - Usage and examplesRANK function - Rank function in Excel - Usage and examples
    the rank function arranges equal numbers of the same rank. however, the duplication will affect the ranking of subsequent numbers. for example, you have the sequence number: 1,2,2,3,4 and are arranged in ascending order, so the order of the number 1 in the series is 5.
  • DCount function in Excel - How to use the DCount function and examples using the DCount functionDCount function in Excel - How to use the DCount function and examples using the DCount function
    dcount function in excel - how to use the dcount function and examples using the dcount function you have a large list of students who want to get a high total score, but don't want to spend a lot of time. in this article, introduce to you the dcount function in excel. help c
  • The search function satisfies many conditions in Excel - Usage and examplesThe search function satisfies many conditions in Excel - Usage and examples
    the search function satisfies many conditions in excel - usage and examples. in the process of processing data in excel many times you need to search for data that satisfies many conditions to extract data, so you are looking for a function that satisfies many things.
  • INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT functionINDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
    indirect function in excel - how to use indirect function and examples using indirect function. you want to refer to a range of data without changing the formula in the cell. the following article introduces you to the indirect function in excel to help you reference
  • Multiple if function - Usage and examplesMultiple if function - Usage and examples
    the following article gives you a detailed guide on how to use the multiple if function with examples. the if function is simplified in the sense that the function tests a value with a given condition, if it satisfies the condition that returns 1 value, if it does not satisfy the condition.
  • SUM function in Excel, sum function and examplesSUM function in Excel, sum function and examples
    sum is a basic excel function that allows users to quickly and accurately calculate the sum of columns or cells in an excel spreadsheet. for an overview of the concept, formula and how to use the sum function in excel, readers can refer to our article below. with many illustrative examples from simple to complex, readers can understand and quickly apply this function to practical work.
  • Exponential functions in Excel - Usage and examplesExponential functions in Excel - Usage and examples
    exponential functions in excel - usage and examples. are you looking for exponential functions in excel to use instead of the exponential operator '^'? so let's learn the exponential function in excel that the article shares below.

Office information