Social Security functions

Excel Functions

Function Name	Category	Description
NAE	SocSec	National average wage index
SocSec	SocSec	Social Security benefit calculation
SSBend1	SocSec	Social Security bend point 1 in PIA formula
SSBend2	SocSec	Social Security bend point 2 in PIA formula
SSBendFam1	SocSec	Social Security bend point 1 in Maximum Family Benefit formula
SSBendFam2	SocSec	Social Security bend point 2 in Maximum Family Benefit formula
SSBendFam3	SocSec	Social Security bend point 3 in Maximum Family Benefit formula
SSCOLA	SocSec	Social Security cost-of-living adjustment
SSCovDomesticEe	SocSec	Social Security coverage threshold for domestic employees
SSCovElectionWrk	SocSec	Social Security coverage threshold for election workers
SSDOBofSSNRAinYear	SocSec	Birth date of a person attaining SSNRA in year
SSEarlyRetAge	SocSec	Social Security early retirement age
SSEarlyRetDate	SocSec	Social Security early retirement date
SSERA	SocSec	Social Security early retirement age
SSExemptHigh	SocSec	Higher exempt amount under the earnings test
SSExemptLow	SocSec	Lower exempt amount under the earnings test
SSFactor	SocSec	Social Security reduction factor for early retirement, or the late increase factor for delayed retirement
SSFRA	SocSec	Social Security full retirement age (same as SSNRA)
SSMax	SocSec	Social Security maximum benefit
SSNormalRetAge	SocSec	Social Security normal retirement age
SSNormalRetDate	SocSec	Social Security normal retirement date
SSNRA	SocSec	Social Security Normal Retirement Age
SSQC	SocSec	Wages needed for a quarter of coverage
SSSGABlind	SocSec	Substantial gainful activity amount – blind
SSSGANonBlind	SocSec	Substantial gainful activity amount - nonblind
SSTaxRate	SocSec	Social Security tax rate (OASDI) for employees
SSTaxRateEr	SocSec	Social Security tax rate (OASDI) for employers
SSTaxRateSE	SocSec	Social Security tax rate (OASDI) for self-employed workers
WageBase	SocSec	Social Security contribution and benefit base
WageBaseMed	SocSec	Medicare Hospital Insurance taxable wage base
WageBaseOld	SocSec	Social Security “old-law” contribution and benefit base
WBTableYear	SocSec	Most recent year in the Social Security wage base table