Latest activity
-
Ggarfieldandew replied to the thread [Answered] Fill each Baseball team specific MV values on specific days.I don't think they approve gambling
-
PHi All, Is there a formula/macro that can sum the number of cells in a column, or a range of columns, that are red and those that are...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Glad to hear that the issue is resolved now. You are most welcome. -
MMaps replied to the thread [Solved] Tax Calculation.Thank you so much Shamima. I am 100% happy now. My query has been solved.
-
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.