Help! Need to Calculate Tax in Google Sheets - Formula Issues with Freelance Income

Hi everyone,
Im working on a spreadsheet in Google Sheets to calculate the correct IRPF (Spanish Income Tax) percentage for my freelance income, but Im encountering some issues with the formula. Heres what I need help with:

I enter my monthly gross income in Column A (e.g., 1000 EUR for each month).

Column B is a running total (accumulated income) that adds up the values in Column A.

I want Column C to automatically calculate the corresponding IRPF for that accumulated income, taking into account the following tax brackets:

Income up to 7,550 EUR: Exempt from tax.
Income between 7,551 EUR and 12,450 EUR: 19% tax rate.
Income between 12,451 EUR and 20,200 EUR: 24% tax rate.
Income above 20,200 EUR: 30% tax rate.
For example, if my total income (B1) is 13,000 EUR, the formula should apply:
19% on the first 4,900 EUR (12,450 - 7,550)
24% on the remaining 550 EUR (13,000 - 12,450)

I've been ChatGTPing the heck out of it with no success

Can anyone guide me on how to fix this formula so that it works consistently, or suggest an alternative approach?
Thank you!

Welcome to the forum.

I hope this works on Google sheets.

I have created a table with your tier values and use this formula to calculate every relevant row, then add them up:

Formula:

Please Login or Register  to view this content.

Good luck!

Thanks! this is what Im getting.
download.png


I forgot to paste the rest of the tax brackets:
35.200 – 60.000 37%
60.000 – 300.000 45%
Over 300.000 49%

I'll provide some context. The gigs can range from a single day to a few months. Every time I get a gig, I get to choose my % of tax withholding. Some weeks I might do 3 or 4 different gigs (single day stuff), but then I might get hired on a TV show that lasts for 3 months. For every single gig, I fill in a cell in Excel with the total amount earned (before taxes).
The idea is to keep track of my income so that, as I enter each amount, Excel tells me what tax percentage I should choose, based on my cumulative income for the year up to that point.

My intention is to create a chart with this information (the tax brackets) so that Excel can calculate the correct tax percentage for each job throughout the year.

For example, if it's February and I've only made €3,000 so far, it should tell me to stick with 0% tax.
Let’s say it’s April and I input a €600 gig that pushes me past the €7,550 exemption threshold — as soon as I enter the €600, it should display the appropriate percentage next to it.
And so on throughout the year.

Do you think that's possible?