Search results

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...

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...

Good day. I have a spreadsheet where I post gas issued to company vehicles. The vehicles do not put in gas everyday. There are days when no gas is issued. I have a sheet on spreadsheet which I call Sourcedata when I do the postings. I have created another sheet called Summary where I want to...

Good day. Trusting you are well. Can you please help me with a formula that will calculate tax from the attached table. The expected tax deduction is on line 24 of the spreadsheet. However, the formula is supposed to be linked on the table below the example. The rebate should be dependant on...

Good day. Good morning. Someone helped me with this formula =IF(A20=0,"",LOOKUP(A20-0.01,$A$4:$A$13,$D$4:$D$13)*(A20-LOOKUP(A20-0.01,$A$4:$A$13,$C$4:$C$13))+MIN(A20,LOOKUP(A20-0.01,$A$4:$A$13,$C$4:$C$13))) to create a deducton table for shortages as per the attached file and it works perfectly...