Help with a budget

[Katinka_Pedersen]

Hi everyone!

My job recently changed their payment system, meaning my hourly rate raises every four hours of work, until 16 hours. Here's an example with random numbers (x is the hrs worked):

x<=4 -> 50

4<x<=8 -> 60

8<x<=12 -> 70

12<x<=16 -> 80

x>16 ->90

I would love to put this information into Excel, but I'm not sure how. Other than that, the sum should have tax subtracted, let's say 5%.

Hope it makes sense, if not, please ask! Thanks for helping:)

[#2 · Accepted solution]

@Katinka_Pedersen 

See the attached demo workbook. I used a lookup range for the hourly rates; this makes it easier to incorporate potential future changes, and also a separate cell for the tax rate.