< Go Back

Round a number up

The general formula for rounding up values in Excel is:

=ROUNDUP(number,digits)

Explanation

To round a number up to any decimal places using excel, the ROUNDUP function is used to return the rounded number to the number of digits specified.

Example

Figure 1. Rounding up Euler’s number using excel

The formula in cell G8 is

=ROUNDUP(E8,F8)

This formula tells Excel to take the Euler’s number in cell E8 and round it to the number of digits in cell F8 (3) with a result of 2.72.

Notice that even though the 2nd digit after the decimal in 2.718282  is one, but it is still returned (rounded up) as 2.

From the example shown, the ROUNDUP function is used to round Euler’s number to a descending order of digits, starting at 5 and moving down past zero to -2.

Note

Note that positive digits round to the right of the decimal point, while negative digits and zero are rounded to the left.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar