Excel Function Translator Logo
    The Excel Translator

    CEILING.PRECISE

    Math & Trig

    Rounds a number up to the nearest integer or to the nearest multiple of significance, always rounding toward positive infinity regardless of the sign.

    Translations
    EnglishCEILING.PRECISE
    FrenchPLAFOND.PRECIS
    SpanishMULTIPLO.SUPERIOR.EXACTO
    GermanOBERGRENZE.GENAU
    ItalianARROTONDA.ECCESSO.PRECISO
    PortugueseTECTO.PRECISO
    DutchAFRONDEN.BOVEN.NAUWKEURIG
    PolishZAOKR.W.GÓRĘ.DOKŁ
    RussianОКРВВЕРХ.ТОЧН
    TurkishTAVANAYUVARLA.DUYARLI
    CzechZAOKR.NAHORU.PŘESNÉ
    HungarianPLAFON.PONTOS
    SwedishRUNDA.UPP.EXAKT
    DanishAFRUND.LOFT.PRÆCIS
    FinnishPYÖRISTÄ.YLÖS.TARKKA
    Syntax
    CEILING.PRECISE(number, [significance])

    Arguments

    • numberThe number to round.
    • significanceOptional. The multiple to round to (default 1). Sign is ignored.(optional)
    Examples
    =CEILING.PRECISE(4.3)
    5

    Rounds up to nearest integer

    =CEILING.PRECISE(-4.3)
    -4

    Always rounds toward +∞ (less negative)

    =CEILING.PRECISE(7,3)
    9

    Rounds up to nearest multiple of 3

    Tips & Best Practices
    • •Available since Excel 2010
    • •Sign of significance is ignored — always treated as positive
    • •Use CEILING.MATH if you need control over negative-number rounding direction
    Common Mistakes
    • •Expecting the significance argument's sign to matter - it's always ignored and treated as positive, so a negative significance doesn't reverse or otherwise change the rounding direction
    • •Assuming CEILING.PRECISE behaves like the legacy CEILING function on negative numbers - CEILING.PRECISE always rounds toward positive infinity (less negative), while classic CEILING's behavior on negatives depended on sign-matching rules
    • •Needing control over which direction negative numbers round and reaching for CEILING.PRECISE instead of CEILING.MATH, which is the version that actually offers that control via its mode argument
    Related Functions
    CEILING.MATHOffers a mode argument for explicit control over negative-number rounding direction, something CEILING.PRECISE's fixed always-toward-positive-infinity behavior doesn't provide.
    FLOOR.PRECISEAlways rounds toward negative infinity, the mirror-image counterpart to CEILING.PRECISE's always-toward-positive-infinity behavior.
    ISO.CEILINGBehaves identically to CEILING.PRECISE, provided as a separate function name for ISO/IEC 29500 standard compatibility.
    Frequently Asked Questions

    Does the sign of significance matter in CEILING.PRECISE?

    No, it's always ignored and treated as positive - passing a negative significance value has no different effect than passing its positive equivalent.

    How does CEILING.PRECISE round negative numbers?

    Always toward positive infinity, meaning toward the less-negative direction - CEILING.PRECISE(-4.3) returns -4, not -5.

    If I need to control which way negatives round, should I use CEILING.PRECISE?

    No, use CEILING.MATH instead - it has a mode argument specifically for that purpose, while CEILING.PRECISE's rounding direction is always fixed.

    Need to translate a formula using CEILING.PRECISE?

    Use our translator to convert your complete formula