Hi Joe,
Here is the logic: If the average indexed monthly earnings are in cell
B15:
=IF(B15>711,0.9*711,0.9*B15)
=IF(B15>4288,0.32*(4288-711),0.32*(B15-711))
=IF(B15>4288,0.15*(B15-4288),0)
Combining these in one cell gives:
=IF(B15>711,0.9*711,0.9*B15)+IF(B15>4288,0.32*(4288-711),0.32*(B15-711))+IF(B15>4288,0.15*(B15-4288),0)
Simplifying components:
=IF(B15>711,639.9,0.9*B15)
=IF(B15>4288,1144.64,0.32*B15-227.52)
=IF(B15>4288,0.15*B15-643.2)
You can combine these also:
=IF(B15>711,639.9,0.9*B15)+IF(B15>4288,1144.64,0.32*B15-227.52)+IF(B15>4288,0.15*B15-643.2)
And there are additional ways to make it shorter but this should do for a
start.
Cheers,
Shane Deven****re
Microsoft Excel MVP
"joetaxpayer" <joetaxpayer@[EMAIL PROTECTED]
> wrote in message
news:NeCdnSNm8dTfbLnVnZ2dnUVZ_jqdnZ2d@[EMAIL PROTECTED]
> From http://www.socialsecurity.gov/OACT/COLA/piaformula.html
> There is this paragraph;
>
> For an individual who first becomes eligible for old-age insurance
> benefits or disability insurance benefits in 2008, or who dies in 2008
> before becoming eligible for benefits, his/her PIA will be the sum of:
> (a) 90 percent of the first $711 of his/her average indexed monthly
> earnings, plus
> (b) 32 percent of his/her average indexed monthly earnings over $711
> and through $4,288, plus
> (c) 15 percent of his/her average indexed monthly earnings over
> $4,288.
>
>
> I would like to write a single line to take the income (shown in an
> adjacent cell) and produce the benefit based on this rule. I'm sure it's
> simple, but I am having a brain freeze. Would someone be so kind as to
> help me?
>
> Joe
> www.blog.joetaxpayer.com
>
|
