Wasn't even sure how to title this. What it boils down to is that I need help with a formula for a report I am working on.
I have certain bench marks that my employees must hit and am working on a spreadsheet to measure these benchmarks. One of the most important is how long it takes to respond to a customer. The target is 4 hours or less. If they hit 4 hours they get a 100% if they respond in lets say three hours they would get 125%. If they respond in 5 hours they only get 75%.
If I take the cell that has the response hours in lets call it cell A2 and divide it by the bench mark that is in B$1$ and there response is 4 hours they receive 100%. However I cant get the less than 4 hours and more than 4 hours figured out. I know it is probably some small thing that I am missing.
Any assistance any one can provide would be great.
Thank you in advance.
Brad
I have certain bench marks that my employees must hit and am working on a spreadsheet to measure these benchmarks. One of the most important is how long it takes to respond to a customer. The target is 4 hours or less. If they hit 4 hours they get a 100% if they respond in lets say three hours they would get 125%. If they respond in 5 hours they only get 75%.
If I take the cell that has the response hours in lets call it cell A2 and divide it by the bench mark that is in B$1$ and there response is 4 hours they receive 100%. However I cant get the less than 4 hours and more than 4 hours figured out. I know it is probably some small thing that I am missing.
Any assistance any one can provide would be great.
Thank you in advance.
Brad