Excel Function Translator Logo
    The Excel Translator

    FLOOR.PRECISE

    Math & Trig

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

    Translations
    EnglishFLOOR.PRECISE
    FrenchPLANCHER.PRECIS
    SpanishMULTIPLO.INFERIOR.EXACTO
    GermanUNTERGRENZE.GENAU
    ItalianARROTONDA.DIFETTO.PRECISO
    PortugueseARREDMULTB.PRECISO
    DutchAFRONDEN.BENEDEN.NAUWKEURIG
    PolishZAOKR.W.DÓŁ.DOKŁ
    RussianОКРВНИЗ.ТОЧН
    TurkishTABANAYUVARLA.DUYARLI
    CzechZAOKR.DOLŮ.PŘESNÉ
    HungarianPADLÓ.PONTOS
    SwedishRUNDA.NER.EXAKT
    DanishAFRUND.GULV.PRÆCIS
    FinnishPYÖRISTÄ.ALAS.TARKKA
    Syntax
    FLOOR.PRECISE(number, [significance])

    Arguments

    • numberThe number to round.
    • significanceOptional. The multiple to round to (default 1). Sign is ignored.(optional)
    Examples
    =FLOOR.PRECISE(4.7)
    4

    Rounds down to nearest integer

    =FLOOR.PRECISE(-4.3)
    -5

    Always rounds toward -∞ (more negative)

    =FLOOR.PRECISE(7,3)
    6

    Rounds down to nearest multiple of 3

    Tips & Best Practices
    • •Available since Excel 2010
    • •Sign of significance is ignored — always treated as positive
    • •Use FLOOR.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 FLOOR.PRECISE behaves like the legacy FLOOR function on negative numbers - FLOOR.PRECISE always rounds toward negative infinity (more negative), while classic FLOOR's behavior on negatives depended on sign-matching rules
    • •Needing control over which direction negative numbers round and reaching for FLOOR.PRECISE instead of FLOOR.MATH, which is the version that actually offers that control via its mode argument
    Related Functions
    FLOOR.MATHOffers a mode argument for explicit control over negative-number rounding direction, something FLOOR.PRECISE's fixed always-toward-negative-infinity behavior doesn't provide.
    CEILING.PRECISEAlways rounds toward positive infinity, the mirror-image counterpart to FLOOR.PRECISE's always-toward-negative-infinity behavior.
    MROUNDRounds to the nearest multiple in either direction, a different strategy than FLOOR.PRECISE's fixed downward rounding.
    Frequently Asked Questions

    Does the sign of significance matter in FLOOR.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 FLOOR.PRECISE round negative numbers?

    Always toward negative infinity, meaning toward the more-negative direction - FLOOR.PRECISE(-4.3) returns -5, not -4.

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

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

    Need to translate a formula using FLOOR.PRECISE?

    Use our translator to convert your complete formula