tax calculator

1. The tax man loves his little games!

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...
2. Power Query vlookup Question

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...
3. Calculate Land Tax in Tasmania - seeking Excel formula

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...
4. Stamp Duty Calculation formula

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...
5. Federal Income Tax Calculator

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...
6. Finding tax percentage based on annual income & State

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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back