Would like to have a cell calculate how much bonus money someone gets based on how efficient they did their job.
Lets say the goal hours to complete a job is 100.
If they complete the job in 100 hours no money goes in the bonus pool
For every hour they can go under the 100 hr goal I would like to add 10.00 to the bonus pool.
For every hour they go over the 100 hr goal I would like to subtract 10.00 from the bonus pool.
Any ideas how to put this together?
Thanks in advance!
Bookmarks