What function/formula should I use?

K

KarenT

Hi
Can you please advise how I would set up a tax calculator. The parameters are as below

Tax thresholds($) Tax rate(%
0 – 6,000
6001 – 21,600 1
21,601 – 58,000 3
58,001 – 70,000 4
70,001 plus 4
I want to be able to enter a gross annual salary and use a formula/function to calculate total tax (taking into account differing thresholds) Can this be done

Thanks
 
R

RagDyer

Please don't multi-post!

See Peo's answer in the Functions group.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi,
Can you please advise how I would set up a tax calculator. The parameters
are as below:

Tax thresholds($) Tax rate(%)
0 - 6,000 0
6001 - 21,600 17
21,601 - 58,000 30
58,001 - 70,000 42
70,001 plus 47
I want to be able to enter a gross annual salary and use a formula/function
to calculate total tax (taking into account differing thresholds) Can this
be done?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What function to use 2
Help please - formula to calculate Tax 4
What Formula Should I Use? 9
What function/formula should I use? 8
What formula/function can I use? 12
Which Finance Function should i use to solve this 5
What function or formula do I use to calculate ROI with this data? 9
Which formula should I use relative to a date. 0

Top