Forum Discussion

dothedew's avatar
dothedew
Copper Contributor
Dec 01, 2018

Help with Vlookup on Taxes

Trying to put one formula in the Taxes field, D8 using VLookup function.

Income tax is structured like this:

  1. AGI is taxed at 3% on the first $5,000
  2. AGI is taxed at 4% on the next $5,000
  3. AGI is taxed at 5% on the amount above $10,000

Total these 3 when AGI is over $10,000

Total only the first two when AGI is greater than $5,000 and less than $10,000

Total only the first one when AGI is less than $5,000

Thanks in advance for any help.

No RepliesBe the first to reply

Resources