Latest activity
-
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...
-
shamimarita replied to the thread [Solved] Help on creating an excel spreadsheet with formulas on Pro Forma Statements.Hello Zebrabeside, You can follow the same Excel structure shown in the previous reply. The External Financing Needed (EFN) can be...
-
shamimarita replied to the thread Time additions dd:hh:mm.Hello Lee, Thanks for sharing the sample. In your sheet, the values in column E are being treated as normal time values (hh:mm:ss), so...