Hello,
I am trying to figure out how to do a formula - if it's even possible.
Basically, I am keeping up with a tracking document for my employees on their job performance and rewarding them with raffle tickets for achieving a certain goal.
For every 25 payments they get + adding 5 Auto Pay, it will equal one ticket. Therefore, if they get 50 payments + 10 Auto Pay, I want it to automatically equal 2 for me. 50 payments + 7 Auto Pay would still equal 1 ticket because they need 3 more Auto Pay to get the second ticket, if that makes sense?
I am currently using Microsoft Excel 2010.
I have attached my document.
Thanks!
Bookmarks