Round Function in Excel


Home >> How to Use Excel Tutorial >> Excel Calculations >> Round Function in Excel



In this tutorial, you will learn how to round numbers in excel. By learning how to round in excel, you will be able to shape all your decimal numbers according to your preference.

The ways of how to round numbers in excel vary greatly. It is because there are many excel round formulas that you can use according to the type of result you want. Those variations make it better for you to understand how to use all of them. This is so you can use whichever formula you need based on your data processing needs.


Why do We Need to Learn How to Round Decimals in Excel?


In numeric data processing on a spreadsheet file, one of the operations we often use is digits rounding. This process is needed if we have various forms of decimals and we want to organize them. Or probably we need a certain number of digits behind the dot for our data processing. These needs surely add the importance to understand how to do rounding in this software.

As an example of this rounding need at work, let’s say we are processing various sales numbers of a company. In the process, maybe we do various calculation operations that produce various decimal forms. These forms are better uniformed so the look of the final results can be better. For the uniformity process, we need to do our rounding process. Because there are usually many numbers to process, then it is better to utilize an automatic way to do it.

Because of that, we need to understand various ways of how to round numbers in excel. In this spreadsheet software, there are various round functions you can use. Your understanding of them is important especially if you often deal with decimals in your spreadsheet file.


What is How to Round Numbers in Excel?


How to round numbers in excel is a process of adding or subtracting the amount of decimal digits in this tool. Various rounding formulas can help you in doing that process. But, of course, you need to be able to use the right formula according to your needs. The reason is because each of these formulas functions differently.


How do You Round in Excel?


The following will explain how to round numbers in excel by using various kinds of formulas. A brief explanation of each formula’ function is given below:
  • ROUND, a formula to solve how to round numbers in excel normally (0-4 down and 5-9 up), based on the number of decimals demanded
  • ROUNDUP, a formula to solve how to round numbers in excel up, based on the number of decimals demanded
  • ROUNDDOWN, a formula to solve how to round numbers in excel down, based on the number of decimals demanded
  • MROUND, a formula to solve how to round numbers in excel normally (0-4 down and 5-9 up), based on the multiplication factor demanded
  • CEILING, a formula to solve how to round numbers in excel up, based on the multiplication factor demanded
  • FLOOR, a formula to solve how to round numbers in excel down, based on the multiplication factor demanded
  • INT, a formula to solve how to round numbers in excel down to the nearest whole number
  • TRUNC, a formula to solve how to round numbers in excel to cut decimals based on the number of decimals demanded

The following will explain the writing process of each of the formula methods one by one.


Method 1: ROUND

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 1-1

  2. Type ROUND (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 1-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 1-3

  4. Input the number of decimal digits demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 1-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 1-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 1-7



Method 2: ROUNDUP

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 2-1

  2. Type ROUNDUP (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 2-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 2-3

  4. Input the number of decimal digits demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 2-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 2-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 2-7



Method 3: ROUNDDOWN

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 3-1

  2. Type ROUNDDOWN (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 3-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 3-3

  4. Input the number of decimal digits demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 3-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 3-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 3-7



Method 4: MROUND

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 4-1

  2. Type MROUND (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 4-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 4-3

  4. Input the multiplication factor demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 4-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 4-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 4-7



Method 5: CEILING

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 5-1

  2. Type CEILING (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 5-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 5-3

  4. Input the multiplication factor demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 5-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 5-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 5-7



Method 6: FLOOR

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 6-1

  2. Type FLOOR (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 6-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

    Round Function in Excel - Screenshot of Step 6-3

  4. Input the multiplication factor demanded / cell coordinate where it is

    Round Function in Excel - Screenshot of Step 6-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 6-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 6-7



Method 7: INT

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 7-1

  2. Type INT (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 7-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign

    Round Function in Excel - Screenshot of Step 7-3

  4. Type close bracket sign

    Round Function in Excel - Screenshot of Step 7-4

  5. Press Enter
  6. The process is done!

    Round Function in Excel - Screenshot of Step 7-6



Method 8: TRUNC

  1. Type equal ( = ) in the cell where you want to put the result in

    Round Function in Excel - Screenshot of Step 8-1

  2. Type TRUNC (can be with large and small letters) and open bracket sign after =

    Round Function in Excel - Screenshot of Step 8-2

  3. Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign

    Round Function in Excel - Screenshot of Step 8-3

  4. Optional:type comma sign ( , ) followed by the number of decimal digits demanded / cell coordinate where it is. If there is no input in this, it will produce a whole number without decimals

    Round Function in Excel - Screenshot of Step 8-4

  5. Type close bracket sign

    Round Function in Excel - Screenshot of Step 8-5

  6. Press Enter
  7. The process is done!

    Round Function in Excel - Screenshot of Step 8-7



Exercise


After you have learned how to round numbers in excel using various formulas, now let’s do an exercise. It is done so you can deepen your understanding of how to use them.

Download the exercise file from the following link and answer the questions. Please download the answer key file if you have done the exercise and are sure about your answers. Or probably when you are confused about how to answer the questions!

Link to the exercise file:
Download here

Questions

  1. What is the rounding result if the digit in the spreadsheet is rounded down to 2 decimal digits?
  2. What is the rounding result if the digit is rounded to 3 multiplication factor?
  3. What is the result if the digit is changed into a whole number using TRUNC?

Link to the answer key file:
Download here


Additional Notes

  • For the formulas with the input of the number of decimals demanded (ROUND, ROUNDUP, ROUNDDOWN, and TRUNC) if you input a minus, then the result will be:
    • (-1) will process your number to the nearest multiplication factor of 10
    • (-2) will process your number to the nearest multiplication factor of 100
    • (-3) will process your number to the nearest multiplication factor of 1000
    • etc
  • To increase or decrease your decimals only on the look, you can use the increase decimal/decrease decimal menu. Click the menu in the Home Tab after putting your cursor in the cell where your number is.

    Round Function in Excel - Screenshot of Decimal Tips 1



    Or please right-click after putting your cursor on that cell. Then choose Format Cells. On the Number Tab, choose Number then change the value in the Decimal Places based on the number of decimals wanted. Then click OK.

    Round Function in Excel - Screenshot of Decimal Tips 2-1



    Round Function in Excel - Screenshot of Decimal Tips 2-2



    However, you must remember that this method only changes the decimal look of your number, not the true value.




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert