HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: RoundUp Function

In Excel, the RoundUp function returns a number rounded up to a specified number of digits. (Rounds away from 0.)

The syntax for the RoundUp function is:

RoundUp( number, digits )

number is the number to round up.

digits is the number of digits to round the number up to.


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=RoundUp(A1, 0) would return 663
=RoundUp(A1, 1) would return 662.8
=RoundUp(A2, -1) would return 60
=RoundUp(55.1, -1) would return 60
=RoundUp(-23.62, 1) would return -23.7