SegRateText
returns all
three rates in a “/” delimited text string for the given month/year. This can
be used as the interest rate parameter for various present value functions. These rates are
published monthly at the IRS web site.
For
example: for August 2017, the function returns “1.93/3.57/4.36”.
Syntax
SegRateText (Date, Month,
[ForPlanYearBeg])
|
Parameter Name |
Description |
|
Year |
Year
or date (not before
August 2007). Instead of a year, you may provide a date as
m/d/year, in which case Month will be ignore. |
|
Month |
Month (not before August 2007).
Ignored if Year is provided as a date. |
|
ForPlanYearBeg |
Needed only if year <
2013. |
Related Topics