This FAQ covers 3 common question types about formula errors, unexpected results, and repeated use across cells, and it also includes a short glossary.
FAQ
What should I do if the INFO function returns an error value?
- Check whether the parameters are entered in the correct format.
- Confirm that the referenced cell content matches the function requirements.
- Review spelling, brackets, and separators in the formula bar.
- If needed, re-enter the function through the Insert Function dialog box.
Why is the INFO result different from what I expected?
- Check whether the referenced range or cell is correct.
- Confirm that the cell format is not affecting how the result is displayed.
- Review the syntax and parameter guidance again.
- Press Enter again after making corrections.
How can I use the INFO function in multiple cells?
- Enter the INFO function in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag down or across to copy the formula to other cells.
- Check whether the copied references need adjustment.
Glossary
| Term | Definition |
|---|---|
| INFO function | A built-in function in WPS Spreadsheet that can be entered in a worksheet cell as part of a formula workflow. |
| Insert Function | A dialog box entry used to search for a function, select it, and fill in its parameters. |
| Formula bar | The input area above the worksheet where you can view and edit the current cell formula. |