XIRR in WPS on Windows FAQ

These FAQs focus on 4 common XIRR issues, including syntax entry, argument matching, unexpected results, and recalculation, plus a 4-term glossary for quick reference.

FAQ

What should I do if the XIRR function returns an error after I enter it?

1. Check whether the formula starts with =.
2. Check whether the parentheses are paired correctly and the separators are valid.
3. Make sure the amount range and date range contain the same number of items.
4. If needed, re-enter =XIRR( and fill in the arguments again by following the hint.

Why does XIRR return an incorrect result or no numeric value?

1. Check whether the cash flow series includes at least one outflow and one inflow.
2. Check whether the dates are valid date values instead of plain text.
3. Confirm that the referenced rows and columns are correct and complete.
4. If needed, add the optional guess argument and calculate again.

How can I view the argument hint for XIRR?

1. Select the target cell.
2. Type =XIRR(.
3. Look for the function hint near the formula entry area.
4. Enter the amount, date, and optional guess arguments in order.

Why did the result not change as expected after I edited the data?

1. Check whether the new data is included in the referenced range.
2. Make sure you edited the original amount or date cells used by the formula.
3. Select the result cell again and review whether the formula range needs to be expanded.
4. Correct the formula and confirm whether the result updates.

Glossary