When using XNPV in WPS Spreadsheet on Windows, the most common questions are about errors, unexpected results, and filling formulas across cells; this FAQ includes 3 quick answers.
FAQ
What should I do if XNPV returns a #VALUE! error?
- Check whether any parameter contains text, extra spaces, or an unrecognized date value.
- Make sure the values range and dates range match one another.
- Clean the source data if needed, then re-enter the formula or reselect the ranges.
Why is the XNPV result different from what I expected?
- Check whether the discount rate was entered correctly.
- Confirm that the reference ranges are complete and not shifted.
- Review the date order, cash flow direction, and cell formats again.
How do I use XNPV across multiple cells?
- Enter the formula in the first target cell.
- Drag the fill handle down or across, or copy and paste the formula.
- Check whether relative and absolute references are set as intended, and use
$when you need to lock references.
Glossary
| Term | Definition |
|---|---|
| XNPV | A financial function used to calculate the net present value of irregular cash flows. |
| Discount rate | The rate used to discount future cash flows back to a present value. |
| Cash flow | An amount flowing in or out on a specific date. |
| Parameter | An input item in a function, such as rate, values, or dates. |