Thanks:  0
Likes:  0

1. I need to write a monthly formula for calculating monthly social security taxes. The formula would be if the sum of the year to date monthly income is less than or equal to 84,900 then take that monthly # times .0765. If the total is greater than or equal to 84,900 then enter a 0. But in a particular month when it exceeds the 84,900 it will take the difference and calculate on ly the difference times the .0765

[ This Message was edited by: swartthydog on 2002-04-24 06:53 ]

2. assuming your first period is listed in A1, second in A2, etc, use this formula on in say, cell B1 and copy down..

=MAX(MIN(A1,A1-(SUM(\$A\$1:A1)-84900))*0.0765,0)

good luck

3. Don't forget that social security taxes are 6.2% up to the social security wage base
(it's \$84,900 this year, but it changes every year). The 1.45% medicare tax is not
limited by income. Therefore, I would propose revising IML's formula...

If the wage base is in D1, then

=MAX(MIN(A1,A1-(SUM(\$A\$1:A1)-\$D\$1))*0.062+A1*0.0145,0)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•