How to Round up Decimals in Excel (5 Methods)

In our dataset, we have 4 different numbers with decimals & we want to round up the decimals to a particular point.

How to Round up Decimals in Excel


Method 1 – Customizing Number Format to Round up Decimals:

  • You can directly customize the number format to round up decimals. However, it won’t round up every time; it depends on the decimal values.
  • If the decimal value is 5 or more, the preceding value will be increased by 1.
  • For example, if you have the number 163.425 and want to round it to 2 decimal places, it becomes 163.43. If you want only 1 decimal place, it’ll be 163.4 (since the following digit after 4 is 2).

Customizing Number Format to Round up Decimals

Steps:

  • Select the number or a range of cells containing numbers.
  • Under the Home tab, from the Number group of commands, select the Expansion flag.

Open Number Format Dialog Box to Round up Decimals

  • Go to the Number category from the list.
  • Type the decimal places, and the sample result will be shown at the top.
  • Press OK to apply the custom format.

Read More: How to Round Up to 2 Decimal Places in Excel


Method 2 – Using Math & Trig Drop-down to Round up an Array of Decimals:

This method allows you to select the ROUNDUP function from the Formulas tab, providing more precision for an array or a large range of cells.

Steps:

  • Go to the Formulas ribbon.
  • From the Math & Trig drop-down, select the ROUNDUP command. A dialogue box named Function Arguments will appear.

Using Math & Trig Drop-down to Round up an Array of Decimals

  • Select the cells containing the numbers you want to round up.
  • Specify a value (e.g., 3) inside the num_digit section. You’ll see a preview of the resultant value.
  • Press OK to get the result.

Select Range and Decimal Place to Round up an Array of Decimals

  • Finally, drag right the Fill Handle icon to apply the same formula to the other columns.

Here are the results for all the numbers rounded up to fixed decimal places:

Read More: How to Get 2 Decimal Places Without Rounding in Excel


Method 3 – Using ROUNDUP Function:

You can directly use the ROUNDUP function in Excel to round up decimals or numbers.

  • The syntax is:
=ROUNDUP(Numbers, num_digits)

In the arguments section,

  • Numbers – Numbers that you want to round up.
  • num_digits – The decimal point or number place to which you want to round up to.

Steps:

  • In Cell D5, insert the following formula:
=ROUNDUP($C5,D$4)
  • Press Enter to get the output.

Using ROUNDUP Function to Round up Decimals

  • Drag down the Fill Handle icon to copy the formula for other numbers in the column.

Use Fill Handle Tool to Round up Decimals

  • Similarly, drag right to copy the formula for other columns.

The final output will show the rounded values.

  • For example, if you round up 163.425 to 3 decimal places, it remains the same (as it has exactly 3 decimal places). Rounding up to 2 decimal places gives 163.43, and for 1 decimal place, it’s 163.5.
  • If you want integers only, use 0 or negative values in the num_digits argument:
    • Using 0: Result = 164 (since 0.425 converts to 1, added to 163).
    • Using -1: Result = 170.
    • Using -2: Result = 200.

Note: The ROUND function may not be suitable if you want to round up only, as it can round either up or down based on the following decimal digit.


Method 4 – Using the CEILING Function to Round up to a Specified Multiple of Numbers & Decimals

  • The CEILING function rounds a number up to the nearest multiple of a specified significance.
  • For example, if we round up 163.425 to the nearest multiple of 0.25, the outcome will be 163.500, and the multiple of 0.25 will apply to the digit right after the decimal point.

The syntax of this function is:

=CEILING(number, significance)

In the arguments section,

  • number– The number you want to round up
  • significance– The number or decimal value that will be multiplied by integers to round up your number to the next multiple of that value.

Steps:

  • Write the following formula in Cell D5:
=CEILING($C5,D$4)
  • Press Enter to get the output.

  • Drag down the Fill Handle icon to apply the formula for the other numbers in the column.

  • Similarly, drag right to copy the formula for other columns.

The final output will resemble the image below:


Method 5 – Using Excel VBA to Round up Decimals:

  • In this method, we’ll apply Excel VBA to round up decimals. A simple code snippet will suffice.
  • Let’s round up the number 163.425 to 2 decimal places.

Steps:

  • Press Alt + F11 to open the VBA window.
  • Click Insert > Module to create a new module.

Using Excel VBA to Round up Decimals

  • Type the following codes:
Sub RoundUp_Using_VBA()
    Dim RUp As Double
     RUp = WorksheetFunction.RoundUp(163.425, 2)
     MsgBox RUp
End Sub
  • Press the Run icon to execute the codes.
  • The code inserts the number and decimal value within the RoundUp VBA function as two arguments.

VBA Codes to Round up Decimals

  • When the Macros dialog box appears, select the Macro Name and press Run.

You’ll receive the rounded number in a message box.


Download Practice Workbook

You can download the practice workbook from here:


Round up Decimals in Excel: Knowledge Hub


<< Go Back to Rounding in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nehad Ulfat
Nehad Ulfat

NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.  In this role, he creates techy content all about Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo