Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a 2 columned, 4 row table in a single cell for multiple row | Excel Discussion (Misc queries) | |||
Can Web Query retrieve a single HTML table cell? | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
single cell formula | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) |