Hello guys.
I have made a sheet preparing payslips for emloyee however I am adding a rule to see if the employees is a Director then the calculations in each columns are done on cumulative basis.
i.e. every employee has monthly LEL(1a) = 6032/12=503, LEL-PT(1b) = 2392/12=199 and PP-UEL(1c)= 8424/12=703
for example a normal employee with 1720 salary a month The boxes 1a=503,1b=199,1c=1702-503-199=1018 and the employee pays national insurance on 1018
for Director a cumulative approach is use. i.e. no insurance is charged till 6032+2392=8424 is reached as see n in the first photo.
In here the director is paid 1720 every month. so the first column-1a only calculates till 6032 then the second column 1b calculates till 2392 and the third column-1c would activate when the total is more than 8424
I need help with formulas to assess the total of the column/todate before do any calculations.
I hope it make any sense to you. I have thinking for two days now but I lose my train of thoughts after a while![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have made a sheet preparing payslips for emloyee however I am adding a rule to see if the employees is a Director then the calculations in each columns are done on cumulative basis.
i.e. every employee has monthly LEL(1a) = 6032/12=503, LEL-PT(1b) = 2392/12=199 and PP-UEL(1c)= 8424/12=703
for example a normal employee with 1720 salary a month The boxes 1a=503,1b=199,1c=1702-503-199=1018 and the employee pays national insurance on 1018
for Director a cumulative approach is use. i.e. no insurance is charged till 6032+2392=8424 is reached as see n in the first photo.
In here the director is paid 1720 every month. so the first column-1a only calculates till 6032 then the second column 1b calculates till 2392 and the third column-1c would activate when the total is more than 8424
I need help with formulas to assess the total of the column/todate before do any calculations.
I hope it make any sense to you. I have thinking for two days now but I lose my train of thoughts after a while
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![111.jpg](/board/proxy.php?image=https%3A%2F%2Fimage.ibb.co%2Fj8qZnA%2F111.jpg&hash=86e731a096b08db9661f25630b98ac6c)
![222.jpg](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2Fd6yb0V%2F222.jpg&hash=abe82b41656e3d567a14b089b0492483)