FLOOR

FLOOR helps you round numbers down to the nearest specified multiple in DBSheet formula fields. It provides the tools you need to calculate results directly in a table, making your work more efficient and helping you accomplish tasks with ease. With FLOOR, you can create a formula field, enter a FLOOR formula with flexible parameter formats, use referenced data ranges, and combine the result with other functions such as IF or AND. Calculated results appear in the formula field immediately, refresh automatically when source data changes, and are also filled automatically after data import. Whether you're setting up calculations in a new formula field, troubleshooting parameter or data type errors, or testing formulas on a small dataset before applying them more broadly, FLOOR helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53