IF and AND formula

[benblee]

I created a Pay Tracker template a while ago and used dates in a similar way to discern between raises and pay changes. I didn’t want my previous entries to be overridden just because my pay rate changed.

There are a few hidden columns and this template does a few different things. It may apply as a strategy for you and it may not. I also have different “scalers” so overtime could be the typical rate multiplied by “1.5” for example. That could be used similarly for VAT.

If you have questions, let me know and I’ll try to better explain the formulas and strategy. And I know it’s not an apples to apples solutions, but may spark some formula ideas.

Pay Tracker Template

I created a Pay Tracker Template to log pay for hourly jobs. There are two pay rates in the example, Office and Field, and then various scalers of these rates, like Overtime at 1.5x regular pay. Bulk pay items are also included, like single sum Bonuses or Reimbursements. You can also track raises and pay changes for both rates without overwriting data previous to these rate changes. There is also a YTD (Year to Date) page with a dropdown to choose the year you’d like to review. All Tables are…