Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Math function

FLOOR

Rounds a number toward zero to the nearest multiple of significance; the older form kept for compatibility.

OccasionalDifficulty 1100 · ProficientUsage rank #179 of 520

Practice · 3 questions →

When to use it

The original round-down-to-a-multiple function, kept for compatibility. Rounds toward zero and needs the number and significance to share a sign. Prefer FLOOR.MATH.

The shape of it

Syntax: =FLOOR(number, significance)

Worked examples

Price to nickels
=FLOOR(4.47,0.05) → 4.45
Down to the nearest 5 cents.
Multiple of five
=FLOOR(23,5) → 20
Down to a multiple of 5.
Negative pair
=FLOOR(-2.5,-2) → -2
Both negative: toward zero.

Worth knowing

FLOOR.MATH replaces it with no sign restriction.
Fine for positive quantities.
Significance 1 is the same as INT for positives.

Where it goes wrong

#NUM! when the signs differ.
Significance of 0 returns #DIV/0!.

SUM SUMIF SUMIFS ROUND ABS SUMPRODUCT

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.