When using the POISSON function in WPS, the most common questions focus on parameter errors, unexpected results, and filling formulas across cells; this FAQ covers 3 common question types.
FAQ
What should I do if the POISSON function returns an error value?
- Check whether each parameter is a valid numeric value and make sure text, spaces, or blank cells are not affecting the result.
- Confirm that you are using English commas instead of full-width punctuation.
- If you used cell references, verify the data format in the referenced cells.
Why is the POISSON result different from what I expected?
- Review the parameter order and the values you entered.
- Check whether your references point to the intended cells.
- If needed, open the function help entry to review the syntax and then adjust the formula.
How do I use the POISSON function in multiple cells?
- Enter
=POISSON(...)in one cell first. - Drag the fill handle down or across, or copy and paste the formula into other cells.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| POISSON function | A built-in function in WPS Spreadsheet used for Poisson distribution related calculations in worksheet cells. |
| Insert Function | A function entry in WPS Spreadsheet that lets you search for a function name and fill in parameters through a dialog box. |
| Formula bar | The input area above the worksheet where you can view or edit the formula in the current cell. |