Excel Formulas to Round a Number Up Using ROUNDUP Function!!

We have already learned how to round down a number in Excel. Likewise, here we will show you how to round a number up in Excel. The ROUNDUP function helps to complete this task easily, even for a large dataset. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• Use the below formula for numbers to round down, regardless of its value.

=ROUNDUP(number,digits)

Syntax Explanations:

• ROUND – In Excel, the ROUNDUP function will help to round a number up to the specified number of digits towards zero.
• Number – It represents the input values from your worksheet.
• Digits – This is the value that specifies how many digits to be rounded.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

• First, we will enter the input values in Column B.
• Here, we need to round up the numbers based on the digits which are given in Column C.

• So, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell.

Verdict:

From this chapter, we have described the simple formula to round a number up in Excel. Let me know if you have any doubts regarding this article or any other article on this site. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Also:

• Excel Formulas to Round Numbers ~ A Complete Tutorial!!
• Formulas to Set the Rank with Ordinal Suffix ~ {Easy Method}
• Excel Formulas to Highlight the Entire Rows Between Two Dates!!