Forum Discussion
Help with a budget
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:)
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.
1 Reply
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.