SCAN
SCAN helps you process and calculate data in WPS Sheets. It provides the tools you need to enter the function, review its syntax and parameters, and troubleshoot common calculation issues, making your work more efficient and helping you accomplish tasks with ease. With SCAN, you can insert the function through the function dialog, type =SCAN(...) directly in a cell or the formula bar, view syntax help after entering =SCAN(, and open detailed function help for parameter guidance. Whether you're checking parameter data types to fix #VALUE! errors, verifying referenced ranges and numeric cell formats when results are unexpected, or filling and copying formulas across multiple cells while managing relative and absolute references, SCAN helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.