When using the INFO function, the most common questions focus on formula entry, arguments, and result checking; this section covers 3 frequent questions and a short glossary.
FAQ
What should I do if the INFO function shows an error?
- Check whether the formula starts with
=. - Confirm that the function name, parentheses, and separators are complete.
- Review the syntax guidance again to verify the argument type and count.
- Press Enter again after correcting the formula.
How can I view help for the INFO function?
- Select the target cell and type
=INFO(. - Watch for the syntax guidance that appears in the editing area.
- Review the argument requirements and example shown there.
- Complete the formula based on the guidance.
Why does the INFO result not match what I expect?
- Check whether the referenced cells, worksheets, or related content are valid.
- Confirm that there are no missing parentheses, incorrect arguments, or nesting issues.
- Reconfirm the formula after editing and review the updated result.
- If needed, break a complex formula into smaller parts for checking.
Glossary
| Term | Definition |
|---|---|
| INFO function | An information function in WPS Spreadsheet used to return specific environment or system-related details. |
| Syntax guidance | The on-screen hint that shows argument requirements and examples while you type a function. |
| Nested formula | A formula structure that includes one function inside another. |
| Cross-sheet reference | A way to use content from another worksheet inside the current formula. |