FLOOR.PRECISE

Rounds a number downwards to the nearest whole number or nearest significant multiple. Positive and negative numbers are both rounded down. If the number or its significance is zero, the function returns zero.

Syntax:

FLOOR.PRECISE(number, significance)

number is required, and is what you want to round.

significance is optional, and the multiple used for rounding number. When significance is not specified, it defaults to 1.

Example:

If A1 contains 23.5, and A2 contains 6:

FLOOR.PRECISE(A1, A2)

returns 18

If A1 contains -10.6, and A2 contains 12:

FLOOR.PRECISE(A1, A2)

returns -12

Number:

Significance:

Result:

18

Application:

Calculating Shipping Crate Requirements

Imagine you work for a company that manufactures products and ships them in crates. To optimize shipping, each crate can hold a maximum of 50 items. You have several orders to fulfill, and you need to calculate the number of full crates you can ship for each order. Any remaining items that don't fill a complete crate will be shipped in a separate, partially-filled crate.

The "floor" function is perfect for this scenario because it rounds the total number of items down to the nearest multiple of the crate's capacity (50).

Here's the data:

	Order ID	Total Items	Crate Capacity	Full Crates to Ship	Remaining Items
	A	B	C	D	E
1	101	235	50	4	35
2	102	150	50	3	0
3	103	280	50	5	30
4	104	499	50	9	49
5	105	50	50	1	0

Explanation of the calculation:

In this example, the formula used to calculate the "Full Crates to Ship" column would be:

FLOOR(Total Items, Crate Capacity)

Let's break down the first row (Order ID 101):

Total Items: 235
Crate Capacity: 50
FLOOR(235, 50) rounds 235 down to the nearest multiple of 50.
The multiples of 50 are 50, 100, 150, 200, 250, etc.
The nearest multiple of 50 that is less than or equal to 235 is 200.
The number of full crates is 200 / 50 = 4.

The "Remaining Items" are then calculated using the MOD function (or simple subtraction):

Total Items - (Full Crates to Ship * Crate Capacity)

For Order ID 101:

235 - (4 * 50) = 235 - 200 = 35

This example effectively demonstrates how a floor function can be used in a practical business context to determine discrete units (like full crates) from a larger quantity.

	Order ID	Total Items	Crate Capacity	Full Crates to Ship	Remaining Items
	A	B	C	D	E
1	101	235	50	4	35
2	102	150	50	3	0
3	103	280	50	5	30
4	104	499	50	9	49
5	105	50	50	1	0

	Order ID	Total Items	Crate Capacity	Full Crates to Ship	Remaining Items
	A	B	C	D	E
1	101	235	50	4	35
2	102	150	50	3	0
3	103	280	50	5	30
4	104	499	50	9	49
5	105	50	50	1	0

	Order ID	Total Items	Crate Capacity	Full Crates to Ship	Remaining Items
	A	B	C	D	E
1	101	235	50	4	35
2	102	150	50	3	0
3	103	280	50	5	30
4	104	499	50	9	49
5	105	50	50	1	0