Tax brackets (Excel)

[MJRomeo81]

Mods can now close this topic. It's all sorted.

Thanks.

[Lasercookie]

"Tax!" refers to the worksheet named "Tax". So "Tax!$G$5" is referring to cell G5 in the worksheet Tax. In this case it is referring to the same worksheet - kind of unnecessary.

I'll take a look at the worksheet and see if I can figure out what you want it to do.

Edit: I'm just going to start from scratch and implement it the way I would
I've already done something similar to this - it's pretty simple.

http://www.ato.gov.au/individuals/content.aspx?doc=/content/12333.htm
Is that the tax table you were talking about? I'll use the 2010-2011 one listed there.

[MJRomeo81]

LOL wow how stupid of me I should have known that. Thanks. I'll now take another look at this.

[MJRomeo81]

Sorry for the double post, but I think I solved my problem. Thanks so much laseredd - my massive mind blank would have kept me up all night.

Thanks + rep.

[Lasercookie]

Good to know, I'll upload my solution anyway for you to check against.

I haven't really checked it for errors but it shows how I would approach it. Basically restating the tax table in an excel vlookup table and then applying the vlookup formulas. I'm not particularly happy with the "more tax" bit - the formula is too messy for my liking, but it does the job. 

[MJRomeo81]

It's all good mate I got my tax calculated weekly and annually for each employee!

Your idea is what I started off with, but since I have no room for that on the spreadsheet, the work needs to be done behind the scenes. (I'm calculating pay slips).

Thanks once again.