The FLOOR function in Google Sheets is a powerful tool used to round numbers down to the nearest multiple of a specified significance. This function is essential for data analysis when you need to align numbers with predefined intervals, ensuring consistency and accuracy in computations.

Syntax

FLOOR(value, significance)

• value: The number you want to round down.
• significance: The multiple to which you want to round the number down.

Example #1

FLOOR(9.8, 1)

This function call rounds down the value 9.8 to the nearest integer (1). The result is 9.

Example #2

FLOOR(15.67, 0.5)

This example rounds down the number 15.67 to the nearest multiple of 0.5. The result is 15.5.

Example #3

FLOOR(-3.2, 1)

Here, the function rounds down -3.2 to the nearest integer (1), resulting in -4.

Error handling

• NUM!: This error occurs when the significance parameter is zero or negative, which is not permissible for rounding operations.
• VALUE!: This error appears when either argument is non-numeric, indicating that the function requires numeric values for proper execution.

Conclusion

In summary, the FLOOR function is an invaluable asset for users of Google Sheets who seek to manage numerical data effectively. By rounding down to specified multiples, it enhances precision in calculations and data organization. Mastering this function can significantly improve the accuracy and reliability of your spreadsheets.