FLOOR

FLOOR helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to round values with a formula, making your work more efficient and helping you accomplish tasks with ease. With FLOOR, you can enter the function directly in a cell or formula bar, view automatic syntax guidance with parameter requirements and examples, use flexible parameters for different calculation scenarios, reference cells across worksheets, and include FLOOR in nested calculations. Results update automatically when source data changes, and you can also trigger recalculation manually if needed. Whether you're correcting formula syntax, checking parameter types and counts, or troubleshooting incorrect results caused by text-formatted numbers or circular references, 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