FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)

FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe) 1
⏱ 1 min readUpdated 5 October 2026

Maths & trigLevel: IntermediateAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. FLOOR.PRECISE in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

FLOOR.PRECISE rounds down to a multiple regardless of signs; negatives round away from zero.

Advertisement

Syntax

=FLOOR.PRECISE(number, [significance])
Argument What it means
number Value
significance Multiple (sign ignored)

Examples

Example 1

=FLOOR.PRECISE(A2,B2)

Result: 4. See the worked example table below for more cases.

FLOOR.PRECISE in practice

Where you will use it

  • Full packs from stock
  • Mixed-sign data
  • Compatibility

Worked example

ValueStepFormulaResult
4.71=FLOOR.PRECISE(A2,B2)4
-4.32=FLOOR.PRECISE(A3,B3)-6
47-12=FLOOR.PRECISE(A4,B4)36

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Negatives move away from zero-4.3 becomes -6 with step 2
Older ExcelNeeds 2010+

FLOOR.MATH

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZCODE Function in Excel: Character Code of the First LetterExcel Functions A–ZFACT Function in Excel: FactorialExcel Functions A–ZGESTEP Function in Excel: Is It at Least the Threshold?
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong