| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The "settlement" is the date a buyer purchases a coupon, such as a bond. |
| | | The "maturity" is the date when the security expires. |
| | | If "settlement" >= "maturity", then #NUM! is returned. |
| | | If "settlement" is not a valid date, then #NUM! is returned. |
| | | If "maturity" is not a valid date, then #NUM! is returned. |
| | | If "maturity" has passed, then #VALUE! is returned. |
| | | If "frequency" is not an integer, then it is truncated. |
| | | If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned. |
| | | If "basis" is left blank, then 0 is used. |
| | | If "basis" is not an integer, then it is truncated. |
| | | If "basis" < 0, then #NUM! is returned. |
| | | If "basis" > 4, then #NUM! is returned. |
| | | Example 1 - |
| | | Example 2 - |
| | | Example 3 - |
| | | Example 4 - |
| | | Example 5 - |
