This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.

Excel function · Statistics

FLOOR

Rounds a number down to the previous multiple of another.

What it does

FLOOR rounds down to the nearest multiple of the number you choose. It suits billing in whole blocks and counting only complete packs.

=FLOOR(number, significance)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,

Time is billed in completed 15-minute blocks. How many minutes are billed for 52 minutes of work?

	A	B
1	Minutes	Billed
2	52	45

The formula in B2:

=FLOOR(A2,15)

Result: 45

The multiples of 15 are 15, 30, 45, 60. The last one that doesn't exceed 52 is 45.

Mixing it up with CEILING. FLOOR always goes down, even for 59 minutes.
Giving a negative number with a positive multiple in older versions, which gives #NUM!.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.