Help with a budget

Occasional Visitor

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:)

1 Reply
best response confirmed by Katinka_Pedersen (Occasional Visitor)


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.