Hello and thank you for your help thus far...
Attached is a sample workbook with:
1) An assumptions page
2) An example of how the "actual payroll" would look based on the assumptions (manually enetered/no formulas)
3) An attempt to solve the problem that did not work - I am fine until I get to month 13 when I have to decide whether or not the employee has earned the increase for that year.
Thanks for your continued assistance!
Hi,
You have a circular argument in your note re row 13. You want a formula in C13 and one of its condition includes the value of C13, i.e. SUM(C2:C13>40000).
Now there's nothing inherently wrong with a circular formula but it's usually best to try and avoid them. And your assumption sheet doesn't seem generalised enough to reflect the Employee title.
It seems to me that you would be better putting actual month end dates on row 2 of the Payroll Budget, adding extra columns at the beginning for Start date, starting salary, four columns for the Y1-4 % increases, and 4 columns which contain formulae that work out when the increases should cut in.
With that basic data then you could more easily construct formulae on the payroll budget sheet using the new data mentioned above and using the dates on row 2 in the IF tests you'll need.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks