shamimarita's latest activity
-
shamimarita replied to the thread 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... -
shamimarita replied to the thread 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 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...
-
shamimarita replied to the thread 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...
-
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...
-
shamimarita replied to the thread Tax Calculation.Hello Maps, Yes, using your spreadsheet as the practical example, the portal value of 652.99 can be matched. In your sheet: Gross...
-
shamimarita replied to the thread Tax Calculation.Good morning. Thank you for the clarification, and no problem at all. That makes much more sense now. Since the portal result is...
-
shamimarita replied to the thread Tax Calculation.Hello Maps, I checked the workbook you attached. The issue seems to be related to the annualization/proration calculation rather than...
-
shamimarita replied to the thread Inventory System on Google Sheets.Hello Andrewalwin, Thanks for your helpful input. Yes, I agree. For this type of inventory tracker in Google Sheets, Apps Script is...
-
shamimarita replied to the thread VBA to calculate tip credits for employees.Hello Rjr, Yes, this can definitely be done with VBA and Worksheet Change events. You actually have two separate tasks: 1. Perform...
-
shamimarita replied to the thread Table function.Hello Dariourzua, Glad to hear that you solved the issue. If you need further assistance, please reach out to us.
-
shamimarita replied to the thread Conditional Format Cells to a specific color based on value in cell.Hello BecJ, You can easily achieve exactly what you want with Conditional Formatting using separate rules (instead of the 3-Color Scale...
-
shamimarita replied to the thread Inventory System on Google Sheets.Hello Jasperstone62, Thanks for your contribution. If you're referring to building or improving an inventory system in Google Sheets...
-
shamimarita replied to the thread Drop down selection.Hello Lee, It sounds like the issue is coming from how XLOOKUP behaves with filtered data. By default, XLOOKUP does not ignore filtered...