Hello, I am new to the group, would really appreciate if anyone can help! would like to get a correct excel formula to work out correct weekly gross salary from Net Salary. (NET TO GROSS)..

TAX is 10% and NI is 11%

Gross Pay 360
Earning at Lower 118
above threshold (360-118)= 242
11% Employee NI (242 @11%) =26.62
Free Pay 179.02
Taxable Pay (360-179.02)=180.98
Tax @10% 18.1
NET PAY 315.28


I have tried the algebra method, but it doesn’t take into account Free Pay for Tax and Earnings at lower or upper level.

Algebra Method doesn’t give me the correct Gross Pay.

(100%-21)*X=315.28
79%/1=0.79
315.28/0.79= 399.09 but this doesn’t equate to 360.00

Thanks you