FLOOR.MATH

This function will round a number downwards to the closest whole number, or to the nearest multiple of significance.

Syntax:

FLOOR.MATH(number, significance, mode)

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

significance is optional, and the multiple used for rounding number.

mode is optional, and does not affect positive numbers. For negative numbers, mode determines if number rounds toward or away from zero.

Example:

If A1 contains 20.5, and A2 contains 3:

FLOOR.MATH(A1, A2)

returns 18

If A1 contains -9.6, and A2 contains 7:

FLOOR.MATH(A1, A2)

returns -14

Number:

Significance:

Mode:

Result:

18

Application:

Calculating the Number of Full Boxes

Imagine you work for a company that manufactures and ships solar panels. Each box can hold a maximum of 3 solar panels. You have a shipment order for a large number of panels, and you need to figure out how many full boxes you can pack. You don't care about the partially filled boxes; you just need to know the number of boxes that will be completely full.

This is a perfect scenario for using the FLOOR.MATH function. The function rounds a number down to the nearest integer, which in this case represents the number of full boxes.

Scenario:

You have several different orders for solar panels. Your goal is to calculate how many full boxes will be shipped for each order.

Function used: FLOOR.MATH(number, [significance], [mode])

number: The total number of solar panels in the order.
significance: We want to round down to the nearest whole number, so we will use a significance of 1.
mode: We will use the default mode.

	Order Number	Total Solar Panels	Formula	Number of Full Boxes	Explanation
	A	B	C	D	E
1	A-101	10	FLOOR.MATH(10/3, 1)	3	10÷3=3.33.... The FLOOR.MATH function rounds this down to 3. This means you can fill 3 boxes completely, with 1 panel left over.
2	B-205	24	FLOOR.MATH(24/3, 1)	8	24÷3=8. The FLOOR.MATH function returns 8, as it is already a whole number. This means you can fill 8 boxes completely with no panels left over.
3	C-312	17	FLOOR.MATH(17/3, 1)	5	17÷3=5.66.... The FLOOR.MATH function rounds this down to 5. This means you can fill 5 boxes completely, with 2 panels left over.
4	D-450	31	FLOOR.MATH(31/3, 1)	10	31÷3=10.33.... The FLOOR.MATH function rounds this down to 10. This means you can fill 10 boxes completely, with 1 panel left over.

In this example, the FLOOR.MATH function allows you to quickly and accurately determine the number of full boxes, which is crucial for logistics, inventory management, and calculating shipping costs based on the number of full containers.