What function/formula should I use?

[Guest]

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

 

[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,

 

[Guest]

Apologies was unsure where to post it!