Search results

Hello Maps, It is possible to show both: the rebate applicable for the current month (Column C), and the year-to-date rebate value (Column D). For the monthly rebate (April 2026 in Column C), use: =IF(DATEDIF(C21,C23,"Y")<60,8200,IF(DATEDIF(C21,C23,"Y")<75,10900,12100))/365*C22 Where: C21 =...

Good day. You can place the rebate formula in a separate cell and then reference that cell inside the PAYE formula. For example, if: Date of Birth is in C21 Pay Date is in C23 Then the rebate formula can be: =IF(DATEDIF(C21,C23,"Y")<60,8200,IF(DATEDIF(C21,C23,"Y")<75,10900,12100)) This...

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. For the year-to-date PAYE calculation using your Column D values, use this formula: =LET( YTDGross,$D$17, YTDDeduct,$D$19, DOB,$C$21, PayDate,$C$23...

Hello Maps, Yes, it is possible. You can use one dynamic formula that checks the employee’s salary bracket and age automatically. For your current spreadsheet, use this formula in the PAYE/tax cell...

Hello Zebrabeside, You can follow the same Excel structure shown in the previous reply. The External Financing Needed (EFN) can be calculated using the balance sheet equation: EFN=Projected Assets−(Debt+Equity+Projected Net Income) For your example: Projected Sales = 9,996 Growth factor =...

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 Excel displays them as clock times instead of elapsed durations. For this type of data, you can use a custom format that supports accumulated time properly...

Hello Maps, Yes, using your spreadsheet as the practical example, the portal value of 652.99 can be matched. In your sheet: Gross Salary = 6849.81 Tax Deduction = 215.00 Taxable Pay = 6849.81 - 215 = 6634.81 Days in Month = 30 Days in Year = 365 So: Annualized Taxable Income: = 6634.81 / 30...

Good morning. Thank you for the clarification, and no problem at all. That makes much more sense now. Since the portal result is actually 652.99, your manual calculation is likely very close to the correct logic already. Yes, it should be possible to work backward from the final figure to...

Hello Maps, I checked the workbook you attached. The issue seems to be related to the annualization/proration calculation rather than the tax table itself. Your sheet currently returns 652.99, but the taxman portal gives 634.81 because the portal likely: annualizes the salary using an exact...

Hello Andrewalwin, Thanks for your helpful input. Yes, I agree. For this type of inventory tracker in Google Sheets, Apps Script is more reliable than a normal timestamp formula because formulas can recalculate and change the timestamp later. A practical setup would be: • Use an entry sheet...

Hello Rjr, Yes, this can definitely be done with VBA and Worksheet Change events. You actually have two separate tasks: 1. Perform automatic calculations in columns N:S whenever a value is entered in column M. 2. Maintain a running sequential count for rows where column M contains a numeric...

Hello Dariourzua, Glad to hear that you solved the issue. If you need further assistance, please reach out to us.

Hello BecJ, You can easily achieve exactly what you want with Conditional Formatting using separate rules (instead of the 3-Color Scale, which creates gradients/shades). Step-by-step solution: Select the range of cells containing your % compliance values (e.g. the whole column or specific cells...

Hello Jasperstone62, Thanks for your contribution. If you're referring to building or improving an inventory system in Google Sheets, the approach usually depends on how dynamic and automated you want it to be. A basic setup can work well with formulas (like SUMIF, FILTER, or QUERY) to track...

Hello Lee, It sounds like the issue is coming from how XLOOKUP behaves with filtered data. By default, XLOOKUP does not ignore filtered (hidden) rows, so it may return a value that isn’t currently visible, or miss what you expect as the “last visible” result. If your goal is to return the last...

Hello Christina, The courses typically offer certificates upon completion. These certificates usually serve as proof of your skills and may help in job applications or professional development. You can check the course details on the official website for any additional instructions on how to...

Hello doodleali, Good point! Text-formatted numbers or hidden spaces are often the reason SUM doesn’t include certain cells. Using ISNUMBER is a great way to check, and converting with Text to Columns or multiplying by 1 usually fixes it quickly. Also, another quick option is using VALUE() or...

You are most welcome. Let us know your feedback!

Hello Jasongonzalez, After converting your data range to an Excel Table, existing charts don't auto-update with new rows because their series still use old static ranges (e.g., 'log'!$A$3:$A$200) instead of dynamic table references. Quick fix (no need to recreate charts): Click the chart →...

Hello Andrewalwin, Tracking multiple loans (different rates, schedules, maturity dates) for repayments, balances, and due dates is straightforward with the right setup. No VBA needed, use PMT, IPMT, PPMT, CUMIPMT, etc., for calculations. Check out our free Multiple Loan Amortization Schedule...