PAYE and NI formulas in Excel

Marcus Fox · 2005-07-27T18:24:02+00:00

Have written a speadsheet to track my weekly wages in Excel, but having problems with formulas for deductions. NI is no problem, as it's just =(GROSS WEEK-94)*11% But PAYE is more complicated. Thinking something along the lines of GROSS WEEK x 52 or 53? - 4895*22 and then /52 again but don't know how to write in the lower rate of 10% for the next 2090. But as I get paid different amounts sometimes each week, this would need to be based on an average figure for GROSS WEEK. Is there a way to write a formula like this in one cell? What's the formula the HMRC use to calculate deduction/credit of PAYE each week? If anyone can figure this out, would be grateful. Marcus

Jul 27, 2005 20 Replies

Rate this thread:

Peter Saxton 21 years ago

It was a typo - it should be 4895 & 6985.

60.50

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required

PAYE and NI formulas in Excel

Related discussions

PAYE issue

What is my PAYE

Temporary contracts and wage allowances - Newbie Q

Join the Discussion

Didn't find your answer?