When using ODDLYIELD, common questions usually involve formula errors, result checking, and repeated use across cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if ODDLYIELD returns an error value?
- Check whether the function name is entered as
ODDLYIELD. - Make sure each parameter uses the correct data type and that text is not entered where a number is expected.
- Confirm that the date, price, redemption value, and coupon frequency inputs are complete.
- Remove extra spaces or unexpected characters, then enter the formula again.
Why does the ODDLYIELD result look different from what I expected?
- Check the order of settlement, maturity, last_coupon, rate, pr, redemption, frequency, and optional basis.
- Make sure the referenced cells point to the correct data range.
- Confirm that numeric values are stored as numbers rather than text.
- If needed, re-enter the arguments one by one through the Insert Function dialog box for comparison.
How can I use ODDLYIELD in multiple cells?
- Enter the ODDLYIELD formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag down or across to copy the formula to other target cells.
- After copying, check whether relative or absolute references match your worksheet needs.
Glossary
| Term | Definition |
|---|---|
| ODDLYIELD | A financial function that returns the yield of a security with an odd last period. |
| settlement | The security settlement date parameter, which indicates when the transaction is settled. |
| maturity | The security maturity date parameter, which indicates when the security reaches maturity. |
| basis | The day count basis parameter used to define the date calculation basis. |