[Solved] Calculate tax up to wage cap

[awascholl]

I am trying to figure out a formula that will calculate a percentage up to a maximum amount of running wages.

For this example, if I need to calculate 5% up to the first $5,000 of wages, but then stop, how to I handle that? In the attached spreadsheet, I also have an example where the wage amount is reached on 4/30/24, but only part of that week's amount is taxed.

[Alex1]

A maximum per day or per week? In your example all dates are in different months.
If per day, use =0.05*MIN(5000;C4) in F4 etc.
Otherwise upload a better example, also with different wages, and indicate which values are expected.

[awascholl]

A maximum amount of wages. Once the employee hits $5,000 of total wages, the calculation ends.

[FJCC]

Do the calculations in columns G and H do what you want. The two columns can be combined into a single calculation. I split them up while I was working out the formulas.

[awascholl]

Do the calculations in columns G and H do what you want. The two columns can be combined into a single calculation. I split them up while I was working out the formulas.

This seems to be what I need, thank you!