Tax Table Formula in Single Cell
 

Look at the following spreadsheet, what is the best way to make the formula
in E9 so that it would apply to any value in E8. Currently the assumption is
made that the value is in the 25% max. tax rate?

http://netmation.com/taxratecalc.xls

Thanks.

Tax Table Formula in Single Cell
 

Try one of these formulas

E9:
=SUM((E8{0,15650,63700,128500,195850,349700})*(E8-{0,15650,63700,128500,195850,349700})*({0.1,0.05,0 .1,0.03,0.05,0.2}))

OR....
F2: =+E2-N(E1)
Copy that formula down through F7

Then....
E9: =SUMPRODUCT((E8A2:A7)*(E8-A2:A7)*(F2:F7))

Does that help?

Regards,

Ron
Microsoft MVP (Excel)

"Al Franz" wrote in message
...
Look at the following spreadsheet, what is the best way to make the
formula in E9 so that it would apply to any value in E8. Currently the
assumption is made that the value is in the 25% max. tax rate?

http://netmation.com/taxratecalc.xls

Thanks.

Tax Table Formula in Single Cell
 

See

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
"Al Franz" wrote:

Look at the following spreadsheet, what is the best way to make the formula
in E9 so that it would apply to any value in E8. Currently the assumption is
made that the value is in the 25% max. tax rate?

http://netmation.com/taxratecalc.xls

Thanks.