Wauvel

Excel like a finance pro.

← The library

Math function

FLOOR.MATH

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

CommonDifficulty 1100 · ProficientUsage rank #141 of 520
Practice · 3 questions →

When to use it

Rounds down to the nearest integer or multiple. The default is toward negative infinity; mode 1 rounds negatives toward zero instead.

The shape of it

Syntax
=FLOOR.MATH(number, [significance], [mode])

Worked examples

  • Down to a whole number

    =FLOOR.MATH(6.7) → 6

    Nearest integer below.

  • Down to a multiple

    =FLOOR.MATH(23,10) → 20

    Down to a multiple of 10.

  • Negative input

    =FLOOR.MATH(-5.5,2) → -6

    Toward negative infinity. With mode 1 the result is -4.

Worth knowing

  • =FLOOR.MATH(A1,"0:30") snaps a time down to the half hour.
  • Volume-price tiers: FLOOR.MATH(qty,100)/100 gives the number of full hundreds.
  • FLOOR.MATH(x,1) equals INT(x).

Where it goes wrong

  • The mode argument only affects negative numbers.
  • Significance of 0 returns 0, not an error.

Related

SUMSUMIFSUMIFSROUNDABSSUMPRODUCT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.