Thread: Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted
View Single Post
  #1   Report Post  
nerrawsl nerrawsl is offline
Junior Member
  
Posts: 1
Default Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted
I need to calculate the federal tax rate. The federal tax rate is a function of the adjusted income and the employee's marital status. Reference the tax tables in the model assumptions and the marital status in the employee information section to construct a formula (or set of nested formulas) to calculate the tax rate.
Reply With QuoteReply With Quote