< Go Back

Excel ROUNDUP function

ROUNDUP function is used to return a number after it is rounded up to the specified decimal places. The function rounds up every number between 1 and 9. This is unlike the standard rounding in mathematics where you round down numbers less than 5 and round up any number between 5 and 9.

The general formula

=ROUNDUP(number, num_digits)

Explanation

number – The is the original number you want to round up.

num_digits – This signifies the number of digits to which you want to round up the original number.

Figure 1. Excel ROUNDUP function

How to use the ROUNDUP function

The ROUNDUP function is similar to the ROUND function. The only difference is that the ROUNDUP function will always round any numbers between 1 and 9 up.

The ROUNDUP function can round both to the left and right of a decimal point.

When num_digits is greater than 0,  the value is rounded up to the right of the decimal point using the given number of decimal places.

When num_digits is less than 0, the original number is rounded up to the left-hand side of the decimal point.

When num_digits = 0,  the original number is rounded up to the nearest whole number.

 

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