FLOOR
FLOOR helps you round a number down to the nearest multiple of a specified significance in WPS Sheets. It provides the tools you need to enter the function accurately and check its syntax, making your work more efficient and helping you accomplish tasks with ease. With FLOOR, you can insert the function through the function dialog, type =FLOOR(...) directly in a cell or the formula bar, review the syntax FLOOR(number, significance), and open detailed help for the function. Whether you're entering formulas manually, verifying parameter requirements, troubleshooting #VALUE! errors caused by text or spaces, checking unexpected results, or filling the formula across multiple cells while managing relative and absolute 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.