Chloe has attended:
Excel Intermediate course
IF formula for Scottish Tax
Hi All,
I currently have a sheet where we need to show the break down of each tax bracket for Scottish tax.
I currently have a sheet for anything over 45% but the under we have to manually do.
The Original UK Tax Breakdown was created before my time and i am struggling to mirror it for the Scottish tax.
Does anyone know how to do a Scottish tax bracket breakdown on excel?
RE: IF formula for Scottish Tax
Hello Chloe,
Thank you for your question. My reply was difficult to put into this chat because of a table, so I have put a link below where you can download the Word document containing my response. If the link doesn't work for you, please email us at info@stl-training.co.uk so that I can email you the response.
https://stlmicrosofttraining-my.sharepoint.com/ :w:/g/personal/marius_barnard_stl-training_co_uk/ERyROqJzcJRCg91Zzp2YlvwBXszLRBUZg-vz_Uva3H4KsQ?e=2PFz4W
Please copy and paste the link above into your web browser to get to the download page.
I hope this helps.
Kind regards
Marius Barnard
STL
RE: IF formula for Scottish Tax
Hi Marius,
Thanks for your help!
Is this a monthly calculation as it isn't currently matching what the HMRC website says.
Would you be able to help with a monthly calculation
RE: IF formula for Scottish Tax
Hi Chloe,
If you could send me some sample Excel data to info@stl-training.co.uk, with instructions, I can have a look at how to calculate these.
Thank you
Marius
RE: IF formula for Scottish Tax
Hi Marius,
I believe I have completed this now,
I changed the figures in the formula myself and I believe i have managed to fix it to monthly.
Thanks for all your help,
May need to give you a message when we have to incorporate the national insurance if we cannot work out.
RE: IF formula for Scottish Tax
Hi Chloe,
Thank you, it's great that you could make the formulas work. Please feel free to use the forum again in future!
Regards
Marius
