Calculate 2022-23 UK Income Tax - Using VLOOKUP In Excel

[@doctorfuzzzdirtbox]

THANK YOU FOR THIS! It was so hard even get Google to recognise what I wanted to ask, let alone find instructions that put things plain and simple, but this does EXACTLY what I wanted. I ended up putting "=IF(C6>12750,C6-12570)/100*20" into one box and I'm done. As someone not crossing any other thresholds, it spits out my base tax rate (before allowance decutions) plain and simple.

[@theexcelhub]

Great, glad to hear that it helped!

[@christinehowell]

Thank you, thank you, thank you!!! I've been battling to get that final figure and you've helped me get the correct sequence of calculations. Very grateful!

[@Shnufulduful]

This is very useful! Is there anywhere I can download this spreadsheet, or your other tutorial spreadsheets?

[@milenahakobyan812]

Thank you so much for this video! It was very well organised and easy to follow.

[@theexcelhub]

I'm glad it helped, thanks for watching!

[@andyf-d4222]

I wish to echo previous comments that this is very useful to know. I have attempted to carry this task myself and the formulas got a little complicated. This is exactly what I was looking for, thank you. I have subbed and liked.

[@theexcelhub]

Thank you very much for your comment Andy!

[@ecocore]

It would be very handy if you could either share the spreadsheet or even just the formulae. You've done a great job explaining it, but It's quite time-consuming taking the formulae down by dictation!

[@nickpll]

This is a great resource. Quite hard to get your head around without help so this is really appreciated! :)

[@theexcelhub]

My pleasure, thanks for watching!

[@clemfisher5727]

Useful calculator. Gets more complicated when you have any investment income as there are some allowances which change depending on the level of your total income. Going to try and do a calculator to include those effects.

[@johnsimmons2035]

I've used this a lot - thank you for posting. Now that the chancellor has announced his 'mini' budget - are you going to update this with the latest rules from April 2023? Thanks again.

[@theexcelhub]

Thanks John and yes, I will be working on this.

[@andypyne]

Since paying into a pension can reduce your tax burden, would the way to calculate this be to make cell C6 (Taxable Income) the value of a calculation of Taxable Income minus Pension Contributions? i.e. Perhaps Cell E4 could be Taxable Income (the current C6 value), then Cell E5 could be Pension Contribution. Cell C6 Could then be Cell E4-E5. Is that a correct assumption?

[@jonathandavies2544]

For some reason this doesnt display right with the figure of £54000 income

[@antst5712]

Great job man! Too many lazy people in the comments begging for a downloadable spreadsheet. Pull your finger out and get some work done.

[@msid5124]

Excellent.. I have same request as user below.. a downloadable file please

[@DrJamesT]

FYI these rates also apply for 2021-2022 Tax return. They are the same.

[@davidparrish5089]

cell B21 - do you really mean Taxable not Payable?

[@Riship001]

where can i download

[@mrrjh5609]

Great points but you guys are do surface level in terms of your analysis. This stems all the way back to the war in Afghanistan, War in Iraq the Arab springs, Two recessions, Ghaddafi, Ukraine War and Covid.