This FAQ covers 4 common questions about the POISSON function in WPS, mainly around formula entry, syntax prompts, result checking, and recalculation.
FAQ
Why does the POISSON function show an error after I enter it?
- Check whether the formula starts with the
=sign. - Check whether the parentheses are paired correctly and whether the parameter separators are correct.
- Confirm that the parameter types and count match the function requirements.
- If a syntax prompt appears, revise the formula based on that prompt and try again.
How do I view the POISSON function description?
- Select the target cell.
- Enter
=POISSON(. - Review the syntax prompt that appears automatically.
- Use the prompt to confirm the parameter description and example format.
How to use the POISSON function in WPS on Windows when the result looks incorrect?
- Check whether the referenced cells are numeric values instead of text-formatted numbers.
- Check whether the formula references the correct worksheet and cell range.
- Check whether nested functions are affecting the final parameter values.
- If needed, press F9 to recalculate and compare the result again.
Why does the result not update after I change the data?
- Make sure you changed the actual cells referenced by the formula.
- Check whether the result cell has already refreshed automatically.
- If not, press F9 to recalculate manually.
- If the issue continues, review the formula references and parameter setup again.
Glossary
| Term | Definition |
|---|---|
| POISSON | A statistical function in WPS Spreadsheets used to calculate Poisson distribution results with given parameters. |
| Syntax prompt | A prompt shown while entering a function that helps you review parameter requirements and example usage. |
| Cross-sheet reference | A way to reference cell data from another worksheet in the current formula. |
| Nested calculation | A formula pattern that places another function or expression inside a function parameter. |