Forum Discussion

Katinka_Pedersen's avatar
Katinka_Pedersen
Copper Contributor
Sep 05, 2022
Solved

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 ...
  • HansVogelaar's avatar
    Sep 05, 2022

    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.