LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Federal Tax Calculation

=MAX(0, 10%*(CD7 - $M$17*134.62 - 102), (15%*(1445 - (1*134.62) - 396))+29.4,
(25%*(CD7 - ($M$17*134.62) - 1306))+165.9, (28%*(CD7 - $M$17*134.62 -
3066))+605.9, (33%*(CD7 - $M$17*134.62 -6404))+1540.54, (35%*(CD7 -
$M$17*134.62 - 13833))+3992)

Gross amt =1440 (CD7)
One withholding allowance =134.62 filing single ($M$17)
Limits a
Less than 102 --- $0.00 tax
102 to 396 --- 10% * (gross-withholding-102)
396 to 1306 --- 15% * (gross-withholding-396)+29.40
1306 to 3066 --- 25% on (gross-withholding-1306)+165.90
3066 to 6404 --- 28% on (gross-withholding-3066)+605.90
6404 to 13833 --- 33% on (gross-withholding-6404)+1540.54
greater than 13833 --- 35% * (gross-withholding-13833)+3992


For some reason this formula picks up 25% portion.

Based on the IRS publication it should be at the 15%? What am I doing wrong
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Federal tax withholding calculations - using IF statements..? clintjjohnson Excel Worksheet Functions 13 April 3rd 23 04:16 PM
how to sum, if column name is F02 and row name is Federal Seema Excel Worksheet Functions 2 January 3rd 08 07:55 PM
Federal and Private Student Loan Consolidation Programs edfed Excel Worksheet Functions 0 May 26th 07 07:00 AM
federal tax tables Bob Excel Worksheet Functions 3 December 7th 05 01:01 AM
Formula to calculate federal income tax mikeburg Excel Discussion (Misc queries) 1 August 26th 05 05:30 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"