Working out national insurance

[Jimleslie1977]

Hello and thaks in advance for any assistance.

I would like to work out national insurance figure on a given salary. To achieve this I would need to break down the salary the first 37700 paying a percentage whilst above that paying another percentage. Only way i could think to achieve this would he to breaknout the salary into 2 columns with the first one being 37700 seconf being yhe remainder and working out on 2 columns. Looking to see if there would be a way to just enter the one column though?

Thanks again

 

[Joe4]

Welcome to the Board!

Yes, you can do it all in one column. The formula would look something like:

=(MIN(sal,37700)*pct1) + (MAX(sal-37700,0)*pct2)

where sal = salary
pct1 = percent 1
pct = percent 2

 

[Jimleslie1977]

Thankyou so much for your help

 

[Joe4]

You are welcome.