Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functionsInterest rate functions\PPA segment rates\SegRateTextLong

SegRateTextLong

SegRateTextLong returns a text string description of the segment rates for the given month/year. These rates are published monthly at the IRS web site.

For example: for August 2017, the function returns “Minimum present value segment rates for August 2017: 1.93%, 3.57%, 4.36%”.

Syntax

SegRateTextLong (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.
Cannot be before 2008.
Optional, not used if Year >= 2013.