How To work out Tax in Excel?

Soldato
Joined
28 Sep 2004
Posts
8,540
Hi there,

Just doing a piece for something, updating some tax, and the formula at the moment just doesn't work and is really old, does anybody know how to take the current take rates.


In Monthly.
Personal Allowance
10% - £179
20% - £2775
40% - anything above this

How could I use IF's and stuff like that to actually get this, is there a universal formula?

Thanks if you can help.
 
Back
Top Bottom