Calculate Tax from Weekly Tax Table?

[SystematicSyntax]

Hi guys,

First post here but I love the power and flexibility of excel and have recently started tracking my financials and have hit a snag in some automation.

I was wondering if there was a formula (simple or complex) that allowed me to calculate the amount of tax that would be taken from a weeks pay.

I mention the weekly tax table as I do not earn a salary (Shift work unfortunately) and I lose money to tax by varying amounts each week dependent upon total amount earned. Is there a way to do this? Would I be required to import the tax table into excel (see attachments - page 5/6/7) - the only things that really relate to me are $357 (as that's just before tax is taken) to $1000 - in a manner that would allow to me to use a formula that references that table(or sheet or whatever) and decides what to deduct? If so, what type of formula(s) would/could I use for such a task?

Any help is appreciated.

[Richard Buttrey]

Hi,

Don't know anything about Oz tax but usually the tax deductible depends on earnings to date in the tax year. In which case you'll need to upload a copy of the table into a list and then use a VLOOKUP() formula to return the relevant tax amount.

[SystematicSyntax]

Sorry for my tardiness in my reply, but thank you. I was hoping I could avoid that but nevertheless I have done it and it does what I want it to. Just the tediousness of entering all the numbers was a drain.