Search results

Thank you so much Shamima. I am 100% happy now. My query has been solved.

Hello Shamima. Once again, thank you for your patience on my query. I however, still cannot get the tax deductible year to date from your formula. Can you please try and apply it on attached spreadsheet on D19 as highlighted.

Thank you once again Shamima. I need the rebate to be equivalent to the current month which April 2026 (column C) and also show it as a year to date value on Column D, IF IT IS POSSIBLE. On the tax deductible both formulas don't work. The first one reacts as though it's a TEXT and the second...

Good day Shamima. Can you also show a formula for the rebate value on a different cell.

Hello Shamima. Thank you for your assistance into my query. The formula is perfect. Just one or two queries pertaining to this: 1. How do you use the same formula to calculate tax for the ten tax periods from July to April 2026. The current tax year runs from July to June. I have added the...

Thanks once again Shamimarita for the formula, it is perfect. The challenge now is if you have 100 employees with different rates and the tax falling into different tax brackets, and the ages, others falling on the rebate of 10900 instead of the 8200. Is it possible to create a formula that can...

Thank you. Can you please use the spreadsheet that I submitted as a practical example for me to understand.

Good morning Shamima. Thank you for getting back to me. Yes I agree that it has to do with annualization/proration. The portal uses the actual number of days in the year which is 365 or 366 if it is a leap year.. Actually the portal tax is 652.99 not 634.81. I got the figures the other way...

Good day. I made a similar post with Excel Forum on the 11 May 2026 and it has not been solved. Can you assist me with a matching formula to the taxman's calculation. There is an annual tax table that has to be used get the tax payable after deducting the tax rebate and the tax deductible. The...

Hi Shamina. I still have a problem with this thread. Can you please help.

Thanks Shamima for your response. I have tried the formula on column G33 it does not give a meaningful answer. I have attached the spreadsheet for your scrutiny.

Thanks Shamimarita for your kind response. However, I would request that we practically use the spreadsheet with your suggested solution. When I try and insert the formular, it throws me into a wilderness. Also, I would like the deduction result to be linked to the months listed on column A.

Good afternoon. I was helped with this formula and it works perfectly. However, when I use the formula monthly as per Column A the deductions apply correctly provided there are zero deductions in the previous months and as long as there are values on the balance. When the balance reaches zero...

Good morning Lutfor. Thank you for your assistance to my query. It seems that this could be a complex exercise if you have to apply this formula to about 100 employees every month. If there is no simpler formula to use, then I will have to calculate the holidays manually. Thanks once again for...

Further to the above, sometimes the employees do work for less than 7 hours after 00.00. Like instead of knocking off at 07.00 the employees not off at 06.00 or 07.30. How can we accommodate those variations?

Thank you for your quick response. Your formula works fine but it misses the minutes when the employee's holiday has minutes outside the hours worked. Like employees who reported for duty on 3 August in the evening shift had to be paid holiday hours from 00.00 to 07.15 on the 4th which is =...

Good day. I have a table that adds total hours worked by employees. I however wish to have a formula that will tell me the number of hours worked on holidays. I have a list of holidays for the year and I wish to create a formula that count the number of hours in one particular month e.g. August...

Yes please. Thank you once again Lutfor.

Thanks once again Lutfor. It seems what I was asking was a bit complicated and not quite possible. But thanks for trying so hard to help me.

Good morning. Thanks once again Lutfor for your response. I see you have given a formula that summarises the total gas issued per vehicle. I actual want the issues itemised on the summary page excluding cells where no gas has been issued in the sourcedata page. 1. The first issue being cell...