The FLOOR.PRECISE function in Google Sheets is a powerful tool used to round down numbers to the nearest integer or to a specified multiple. This function is particularly useful for financial calculations, data analysis, and anywhere precision in rounding is required.

Syntax

FLOOR.PRECISE(value, [significance])

• value: The numeric value you want to round down.
• significance: The multiple to which you want to round down. This parameter is optional; if omitted, the function defaults to 1.

Example #1

FLOOR.PRECISE(5.9)

This function will round down 5.9 to the nearest whole number, resulting in 5.

Example #2

FLOOR.PRECISE(7.8, 0.5)

This will round down 7.8 to the nearest multiple of 0.5, giving a result of 7.5.

Example #3

FLOOR.PRECISE(-2.3)

In this case, -2.3 is rounded down to the nearest whole number, which results in -3.

Error handling

• NUM!: This error occurs if the value provided is not a number.
• VALUE!: This error appears when the significance parameter is a non-numeric value.

Conclusion

In summary, the FLOOR.PRECISE function is an essential tool for anyone needing to round down numerical values in Google Sheets with precision. By understanding its syntax and practical applications through examples, users can leverage this function effectively in various data handling tasks.