You are a tax accountant and you have a table of income tax brackets in A3:B7. One
Fantastic news! We've Found the answer you've been seeking!
Question:
You are a tax accountant and you have a table of income tax brackets in A3:B7. One question your clients often have is, how close are they to the next highest tax bracket? Suppose their current income is in cell C1. Write a formula to go in D1 that would tell them how many more dollars they can earn before they hit the next tax bracket. For example, if they currently earn $20,000, the answer would be $80,000. If they currently earn $450,000, the answer would be $50,000.
Related Book For
Taxes and Business Strategy A Planning Approach
ISBN: 9780132752671
5th edition
Authors: Myron Scholes, Mark Wolfson, Merle Erickson, Michelle Hanlon
Posted Date: