Math & Trig

FLOOR.PRECISE Function in Excel

Rounds a number down to the nearest integer or to the nearest multiple of significance, regardless of sign.

Syntax

  • =FLOOR.PRECISE(number, [significance])

Arguments

  • number (required): Number to round down
  • significance (optional): Multiple to round to

Examples

  • =FLOOR.PRECISE(4.7) - Round down to integer - Result: 4
  • =FLOOR.PRECISE(-4.7) - Round negative down - Result: -5

FLOOR.PRECISE in reporting workflows

  • Use absolute references when copying formulas across rows.
  • For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
  • Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

  • Always rounds toward zero for positive, away for negative

Use cases

  • Consistent rounding
  • Financial calculations
  • Data processing

Frequently asked questions

  • What is the FLOOR.PRECISE function in Excel? FLOOR.PRECISE rounds a number down to the nearest integer or to the nearest multiple of significance, regardless of sign. The syntax is =FLOOR.PRECISE(number, [significance]). Typical use cases include consistent rounding, financial calculations, data processing.
  • How do I use the FLOOR.PRECISE function? To use FLOOR.PRECISE, type =FLOOR.PRECISE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What happens if FLOOR.PRECISE encounters errors? If FLOOR.PRECISE encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
  • Why is FLOOR.PRECISE not working in my Excel? Common issues with FLOOR.PRECISE include Always rounds toward zero for positive, away for negative. Start by checking the syntax =FLOOR.PRECISE(number, [significance]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.