Simple Tax/N.I calculator

[john.b]

Hi

I know this is probably a common one but I just need a formula to do the full tax and N.I deductions from a gross income to leave a net profit.
I can do this with individual cells for tax and N.I, then in another cell deduct them from my gross to leave my take home pay...
But can i just have one formula to input into one cell so its alot more neater.

Simple I think to the wizards on here...

Much appreciated folks!

J.Bruce

[martindwilson]

=gross pay-(tax+ni) just put the cell reference with the gross pay say in a1 then =a1-(formula for ni)-(formula for tax) all in one cell or
=a1-((formula for ni)+(formula for tax) )

[oeldere]

Please Login or Register  to view this content.

You can use a helpcollumn and put it out of the printarea.

You can use a helpsheet and put the formula in the helpsheet.

You can use a helpcollumn and hide it.

[royUK]

You need to allow for different tax rates based on your annual earnings

[john.b]

This formula worked perfect =SUM(B2-(B2-155.94)*0.2)-(B2-146)*0.12

The Tax and N.I figures are our weekly allowances here in the UK

Thanks for all the support folks much appreciated

[Cutter]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save