|
What Formula Would Apply This Federal Tax Schedule In Excel? |
If over...... but not over...... hide............ of excess over
102......... 389................... 10%.................... 102
389......... 1289................. 28.70+15%........ 389
1289 ...... 2964................. 163.70+25%......
| Answer: Let's say your tax schedule is at A2:D5 (with an additional row for <$102 taxable gains): _|___A_______ B________C __________D___ 2|___ 0______ 102_______0 ___________0% 3|__102_____ 389_______0 ___________10% 4|__389____ 1,289____28.70 __________15% 5|_1,289____ |
| ad2 |
