tax calculator

Hi, I know i can get this but i have been looking for too long and i need a fresh pair of eyes... In the UK we have different tax brackets applied to work out the total amount to be deducted from a salary and paid to the nice tax man. So, if your annual salary was £150k, you wouldn't pay any...

Hi everyone. Has anyone ever used a large table (2 million rows) in power query as a lookup table in a regular vlookup formula in an excel sheet? I'm not talking about a vlookup between 2 tables in power query itself. The large lookup table would be in power query and I want to use a vlookup...

Hi guys, I posted asking for help for a stamp duty calculator recently and received some awesome solutions from the users on here. I tried tweaking the formula for this exercise but couldn't get my head around it. This time I'm trying to calculate land tax due for properties in Tasmania using...

Hi all, I'm creating a property investment calculator and I'm trying to automate the stamp duty calculation with a formula rather than checking the government site for each and every property analysed. Eg, Cell B2 contains the purchase price, Cell J2 needs to show the TAS Stamp Duty payable on...

I own a tax prep firm and trying to make a spreadsheet to post on my website to give my clients an idea of what they are due back or owe. I have gotten stuck. I set up match and index functions for Earned income credit and tax table, calc for exemptions, and others to tie everything in. My...

I need for the user to be able to input there annual salary, then select there state (from a pull down, that is generated from a list) I need a formula too take that information go through and find the persons state. Then basically scan through that individual states tax brackets & return the...