When using the INFO function, users usually ask about 3 areas: formula errors, syntax guidance, and unexpected results; this section covers the top 3 questions.
FAQ
What should I do if the INFO function shows an error?
- Check whether the formula starts with
=. - Make sure the parentheses are complete and the parameter count is correct.
- Re-enter
INFO(and use the syntax guidance to correct the parameter before pressing Enter.
How can I view INFO function guidance in WPS on Windows?
- Type
=INFO(in a cell or in the formula bar. - Review the syntax guidance and example shown on screen.
- Continue entering the parameter to confirm that the formula matches your worksheet need.
Why is the INFO function result not correct?
- Check whether the referenced content or parameter format is correct.
- Confirm that related cells are not using text-formatted values that affect the calculation.
- Recalculate the worksheet and review the result again.
Glossary
| Term | Definition |
|---|---|
| INFO function | A spreadsheet function in WPS that returns a specified type of environment-related information. |
| Syntax guidance | On-screen help shown during formula entry, such as parameter requirements, examples, or input hints. |
| Formula bar | The input area above the worksheet that lets you view and edit the current cell formula. |