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