Thread: Income tax withholding tables in Excel?
View Single Post
  #5   Report Post  
jerry_maguire jerry_maguire is offline
Junior Member
  
Posts: 25
Default Calculate total income tax on excel
To calculate total income tax based on multiple tax brackets, you can use VLOOKUP. I hope the following formula helps:

=VLOOKUP(inc,rates,3,1)+(inc-VLOOKUP(inc,rates,1,1))*VLOOKUP(inc,rates,2,1)

Regards,
Jerry M.
Reply With QuoteReply With Quote