Excel Function Translator Logo
    The Excel Translator

    ROUNDUP

    Math & Trig

    Rounds a number up, away from zero, to a specified number of digits.

    Translations
    EnglishROUNDUP
    FrenchARRONDI.SUP
    SpanishREDONDEAR.MAS
    GermanAUFRUNDEN
    ItalianARROTONDA.ECCESSO
    PortugueseARREDONDAR.PARA.CIMA
    DutchAFRONDEN.BOVEN
    PolishZAOKR.W.GÓRĘ
    RussianОКРУГЛВВЕРХ
    TurkishYUKARI_YUVARLA
    CzechROUNDUP
    HungarianKEREKÍTÉS.FEL
    SwedishAVRUNDA.UPPÅT
    DanishAFRUND.OP
    FinnishPYÖR.KERR.YLÖS
    Syntax
    ROUNDUP(number, num_digits)

    Arguments

    • numberThe number to round up
    • num_digitsNumber of decimal places
    Examples
    =ROUNDUP(3.14159,2)
    3.15

    Rounds up to 2 decimals

    =ROUNDUP(21,-1)
    30

    Rounds up to nearest 10

    =ROUNDUP(-3.2,0)
    -4

    Rounds away from zero

    Tips & Best Practices
    • •Always rounds away from zero
    • •Negative num_digits rounds to left of decimal
    • •Use for conservative estimates
    Common Mistakes
    • •Confusing ROUNDUP with ROUND, then being surprised when a value like 2.01 rounds up to 3 with 0 digits instead of rounding normally
    • •Applying ROUNDUP to negative numbers and expecting a smaller (less negative) result - 'up' means away from zero, so the result actually gets more negative
    • •Using a negative num_digits and forgetting it still rounds away from zero, the same behavior as with positive digit counts
    Related Functions
    ROUNDDOWNAlways rounds toward zero instead of away from it
    ROUNDRounds normally based on standard rounding rules rather than always rounding away from zero
    CEILINGRounds up to the nearest multiple of a specified value, rather than to a number of decimal places
    Frequently Asked Questions

    Does ROUNDUP always round to a bigger number?

    It rounds away from zero, which means a negative number becomes more negative, not larger - -2.1 rounds up to -3, not -2.

    What's the difference between ROUNDUP and CEILING?

    ROUNDUP rounds to a specified number of decimal places. CEILING rounds up to the nearest multiple of a number you choose, like the nearest 0.05 or nearest 10.

    How do I always round a price up to the next whole number?

    Use ROUNDUP(A1,0) to round up to the nearest whole number, regardless of the decimal value.

    Need to translate a formula using ROUNDUP?

    Use our translator to convert your complete formula