Latest activity
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Try this formula there: =MIN(D17*5%,215*((YEAR($C$23)-YEAR($C$31))*12+MONTH($C$23)-MONTH($C$31)+1)) For your spreadsheet... -
shamimarita replied to the thread [Solved] Nested If function not working.Hello TrevorWestbrook, Thanks for your feedback. Keep contributing on the ExcelDemy forum to help each other.
-
MMaps replied to the thread [Solved] Tax Calculation.Hello Shamima. Once again, thank you for your patience on my query. I however, still cannot get the tax deductible year to date from...
-
Sstrsbtitest updated their status.strsbtitest
-
TTrevorWestbrook replied to the thread [Solved] Nested If function not working.Good explanation - the early TRUE short-circuit is what trips most people up with nested IFs. The LOOKUP approach is definitely cleaner...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, It is possible to show both: the rebate applicable for the current month (Column C), and the year-to-date rebate value...
-
MMaps replied to the thread [Solved] Tax Calculation.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...
-
shamimarita replied to the thread [Solved] Tax Calculation.Good day. You can place the rebate formula in a separate cell and then reference that cell inside the PAYE formula. For example, if...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, this can be done. Since your tax year runs from July to June, use the tax period start and end dates in your sheet...
-
MMaps replied to the thread [Solved] Tax Calculation.Good day Shamima. Can you also show a formula for the rebate value on a different cell.
-
MMaps replied to the thread [Solved] Tax Calculation.Hello Shamima. Thank you for your assistance into my query. The formula is perfect. Just one or two queries pertaining to this: 1. How...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, it is possible. You can use one dynamic formula that checks the employee’s salary bracket and age automatically. For...
-
premierpsychiatry updated their status.Premier Pain Centers & Premier Psychiatry in Richardson provides compassionate care for mental health and pain management. We offer... -
MMaps replied to the thread [Solved] Tax Calculation.Thanks once again Shamimarita for the formula, it is perfect. The challenge now is if you have 100 employees with different rates and...