When using ODDFRRICE, the most common issues fall into 3 areas: formula errors, unexpected results, and batch fill; this FAQ includes 3 common questions.
FAQ
What should I do if ODDFRRICE returns an error value?
- Check whether the function name is spelled correctly as
ODDFRRICE. - Make sure all required arguments are complete, especially dates, rate, yield, and redemption value.
- Confirm that referenced cells use valid date or numeric formats instead of plain text.
Why is the calculation result different from what I expected?
- Review the settlement date, maturity date, issue date, and first coupon date.
- Check whether the rate, yield, redemption value, and frequency match your calculation conditions.
- Recheck the argument order against the function guidance before confirming the formula.
How can I use ODDFRRICE across multiple cells?
- Enter the formula in the first cell and confirm that the result is correct.
- Select that cell and drag the fill handle across the target range.
- Check whether relative and absolute references match your worksheet needs.
Glossary
| Term | Definition |
|---|---|
| ODDFRRICE | A financial function used to calculate the price of a fixed-interest security with an odd first coupon period. |
| Function arguments | The input values that define how the function calculates, such as dates, rate, yield, and redemption value. |
| Formula bar | The input area above the worksheet where you can view and edit the active cell formula. |