Spreadsheet income tax formula

[Rollin]

Does anyone have a formula that I can just paste into a cell which will then calculate take home pay?
Needs to take into account personal allowance reduction at certain income levels too. I don't really need each deduction listed separate, just the bottom line.
I found a couple but I'm not great with spreadsheets and they don't seem to work or I'm doing something wrong.

[anonymous-user]

There are a number of online calculators and some will even adjust for your tax code. For instance,

https://www.thesalarycalculator.co.uk/salary.php

[Mr Pointy]

Sorry, this is of no help but I was amused to see the only two posts were by Rockin' & Rollin'.

[uknick]

It's not really possible to have just one formula to tell your tax due, due to all the possibilities around that affect what tax you pay.

As said, use one of the web sites.

[anonymous-user]

Mr Pointy said:

I was amused to see the only two posts were by Rockin' & Rollin'.

Every day's a party!

[Butter Face]

https://listentotaxman.com/

Just makes life easier

[Eric Mc]

I actually use that for quick PAYE "what if" type calculations. It's faster and easier to use than the formal PAYE software I use for my clients.

The problem with UK tax calculations is that they can be immensely complicated in some circumstances - and even more so when you bring in the National Insurance aspects as well.

[JulianPH]

Eric Mc said:

I actually use that for quick PAYE "what if" type calculations. It's faster and easier to use than the formal PAYE software I use for my clients.

The problem with UK tax calculations is that they can be immensely complicated in some circumstances - and even more so when you bring in the National Insurance aspects as well.

Hi Eric, nothing to do with the topic but just wanted to ask after you.

Cheers