INDIRECT

INDIRECT helps you enter and use a built-in WPS Sheets function for data processing and calculation. It provides the tools you need to add the function accurately, review its syntax, and troubleshoot common errors, making formula work more efficient and helping you accomplish tasks with ease. With INDIRECT, you can insert the function through the function dialog, type =INDIRECT(...) directly in a cell or the formula bar, view parameter guidance, and open detailed help for the function. You can also check issues such as #VALUE! errors, incorrect reference ranges, text-formatted numbers, and parameter formatting, then copy or fill the formula across multiple cells while managing relative and absolute references. Choose the documentation below that best matches your needs to learn more.

Windows