P
peterylo
Heads Up. Attachment won't take excel. I have to relearn how to do
zip and will add this later.
I have noticed various queries regarding calc of fed tax. I have thi
need also, and have set up a Vlookup mechanism. But now I have a muc
simpler method. It will handle rates for different years, and all ta
status.
This is my first time here and I just noticed the attachment option.
But here are the higlights:
1) Put your input on one line. The M is MFJ, and the 90000 is the agi.
m 2012 90000
2) Set up a range for the years and tax status. The following show
2011 and 2012 and Single and MFJ.
a) You should recognize most of the columns.
b) The column with the "error" is the IF statement. It will show "t
(true) only once regardless of year or tax status. The T shows way dow
in 2012 M.
c) When the column is true, the tax is calculated. (See attachment).
3) In the Tax column, use autosum so the tax appears in only one cell.
(See attachment. Its all muddled in this rich text).
2011 s $0 $8,500 error 10% $0 $0
2011 s $8,500 $34,500 error 15% $850 $0
2011 s $34,500 $83,600 error 25% $4,750 $0
2011 s $83,600 $174,400 error 28% $17,025 $0
2011 s $174,400 $379,150 error 33% $42,449 $0
2011 s $379,150 $10,000,000 error 35% $110,016 $0
2012 s $0 $8,500 error 10% $0 $0
2012 s $8,500 $34,500 error 15% $850 $0
2012 s $34,500 $83,600 error 25% $4,750 $0
2012 s $83,600 $174,400 error 28% $17,025 $0
2012 s $174,400 $379,150 error 33% $42,449 $0
2012 s $379,150 $10,000,000 error 35% $110,016 $0
2011 m $0 $8,500 error 10% $0 $0
2011 m $8,500 $34,500 error 15% $850 $0
2011 m $34,500 $83,600 error 25% $4,750 $0
2011 m $83,600 $174,400 error 28% $17,025 $0
2011 m $174,400 $379,150 error 33% $42,449 $0
2011 m $379,150 $10,000,000 error 35% $110,016 $0
2012 m $0 $8,500 error 10% $0 $0
2012 m $8,500 $34,500 error 15% $850 $0
2012 m $34,500 $83,600 error 25% $4,750 $0
2012 m $83,600 $174,400 t 28% $17,025 $18,817
2012 m $174,400 $379,150 error 33% $42,449 $0
2012 m $379,150 $10,000,000 error 35% $110,016 $0
A single answe
----------------------------------------------------------------------------> $18,81
zip and will add this later.
I have noticed various queries regarding calc of fed tax. I have thi
need also, and have set up a Vlookup mechanism. But now I have a muc
simpler method. It will handle rates for different years, and all ta
status.
This is my first time here and I just noticed the attachment option.
But here are the higlights:
1) Put your input on one line. The M is MFJ, and the 90000 is the agi.
m 2012 90000
2) Set up a range for the years and tax status. The following show
2011 and 2012 and Single and MFJ.
a) You should recognize most of the columns.
b) The column with the "error" is the IF statement. It will show "t
(true) only once regardless of year or tax status. The T shows way dow
in 2012 M.
c) When the column is true, the tax is calculated. (See attachment).
3) In the Tax column, use autosum so the tax appears in only one cell.
(See attachment. Its all muddled in this rich text).
2011 s $0 $8,500 error 10% $0 $0
2011 s $8,500 $34,500 error 15% $850 $0
2011 s $34,500 $83,600 error 25% $4,750 $0
2011 s $83,600 $174,400 error 28% $17,025 $0
2011 s $174,400 $379,150 error 33% $42,449 $0
2011 s $379,150 $10,000,000 error 35% $110,016 $0
2012 s $0 $8,500 error 10% $0 $0
2012 s $8,500 $34,500 error 15% $850 $0
2012 s $34,500 $83,600 error 25% $4,750 $0
2012 s $83,600 $174,400 error 28% $17,025 $0
2012 s $174,400 $379,150 error 33% $42,449 $0
2012 s $379,150 $10,000,000 error 35% $110,016 $0
2011 m $0 $8,500 error 10% $0 $0
2011 m $8,500 $34,500 error 15% $850 $0
2011 m $34,500 $83,600 error 25% $4,750 $0
2011 m $83,600 $174,400 error 28% $17,025 $0
2011 m $174,400 $379,150 error 33% $42,449 $0
2011 m $379,150 $10,000,000 error 35% $110,016 $0
2012 m $0 $8,500 error 10% $0 $0
2012 m $8,500 $34,500 error 15% $850 $0
2012 m $34,500 $83,600 error 25% $4,750 $0
2012 m $83,600 $174,400 t 28% $17,025 $18,817
2012 m $174,400 $379,150 error 33% $42,449 $0
2012 m $379,150 $10,000,000 error 35% $110,016 $0
A single answe
----------------------------------------------------------------------------> $18,81