ATAR Notes: Forum
VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: MJRomeo81 on August 13, 2011, 09:25:55 pm
-
Mods can now close this topic. It's all sorted.
Thanks.
-
"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.
-
LOL wow how stupid of me I should have known that. Thanks. I'll now take another look at this.
-
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.
-
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.
-
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.