I know most people don't need this sort of information, but since I just entered it into a spreadsheet and found the information wrong in Co-Pilot, I thought I'd share the correct information. In the UK, NI rates can be found here and income tax rates can be found here. The formula to calculate NI is as follows. I've used the LET function to make it easier to read. This presumes the annual salary is in cell A1. If you want a monthly figure, you will need to divide PT and UEL by 12 (directly in the formula eg “12570/12”) =LET ( salary , A1 , PT , 12570 , UEL , 50270 , rate1 , 0.08 , rate2 , 0.02 , IF ( salary <= PT , 0 , IF ( salary <= UEL , ( salary - PT ) * rate1 , ( UEL - PT ) * rate1 + ( salary - UEL ) * rate2 ) )
) The UK Tax calculation would look like this. It has a lot of variables. =LET ( salary , A1 , pension_rate , 5%, pension_contrib , salary * pension_rate , adjusted_salary , salary - pension_contrib , base_PA , 12570 , BR , 50270 , HR , 125140 , rate_basic , 20% , rate_higher...