I am new to the site and I have been having an issue I can not figure out! I am working on our payroll program, and I want Excel to add a specific amount, say 24, to every employees bank of hours monthly. I want this to be done automatically without having to enter a figure. So for example on the first of ever month the program would add these hours to a column "A". I have the complete program done except for this.
After it adds these hours in to column "A" I need the cell to have a maximum amount, say 200, that it will not allow it to exceed. Anything over that 200 I need to automatically deduct said amount and multiply it by $10. So as an example if employee "Ben" has earned 180 hours in his bank, March first he will get 24 hours added to that amount. So he would have 204. Then it would deduct 4 hours, keeping him at max amount of 200, and multiply 4 by $10= $40.
Can this be done?
After it adds these hours in to column "A" I need the cell to have a maximum amount, say 200, that it will not allow it to exceed. Anything over that 200 I need to automatically deduct said amount and multiply it by $10. So as an example if employee "Ben" has earned 180 hours in his bank, March first he will get 24 hours added to that amount. So he would have 204. Then it would deduct 4 hours, keeping him at max amount of 200, and multiply 4 by $10= $40.
Can this be done?
