The FLOOR.MATH function in Google Sheets is a versatile tool that enables users to round numbers down to the nearest specified integer multiple of significance. This function can be particularly useful for applications in finance, inventory management, and any calculations requiring precise adjustments to figures.

Syntax

FLOOR.MATH(value, [significance], [mode])

• value: The number you want to round down.
• significance: (Optional) The multiple to which you want to round down. Default is 1.
• mode: (Optional) A parameter determining how to handle negative numbers. Use 0 to round toward 0 or 1 to round away from 0. Default is 0.

Example #1

FLOOR.MATH(5.7)

This function rounds down 5.7 to the nearest integer, resulting in a value of 5.

Example #2

FLOOR.MATH(5.7, 0.5)

Here, the function rounds down 5.7 to the nearest multiple of 0.5, which results in 5.5.

Example #3

FLOOR.MATH(-5.7, 1, 1)

This call rounds -5.7 away from 0 to the nearest integer multiple of 1, yielding a value of -6.

Error handling

• VALUE!: This error indicates that the value input is not a number, requiring numerical input to process the function properly.
• NUM!: This error appears if the significance parameter is set to 0, as division by zero is not permissible in mathematical functions.
• N/A: This indicates that the function’s conditions were not met, often due to incorrect input types or parameters out of expected ranges.

Conclusion

In summary, the FLOOR.MATH function is an essential tool in Google Sheets for accurately rounding numbers to meet specified criteria. Whether for simple rounding or more complex requirements, this function provides flexibility in managing numerical data effectively.