Hi. I am compiling a workbook for managers to use to easily calculate
bonuses for employees. I have figured out most of it but am having a
problem where two different criteria need to be viewed for one
formula:
Call score bonus %
91+ 8
85-93.9 6
86-87.9 3
<86 0
rollovers Bonus 5
10+ 2
<9 0, but the bonus numbers on call scores above bump up
to 10, 7, and 3 respectively if a zero is received here.
I have attempted a number of If, And, Count, etc. and can get it to
work part-way, but not for every different possibility. Any assistance
would be greatly appreciated.
--
jiffy97
------------------------------------------------------------------------
jiffy97's Profile:
http://www.excelforum.com/member.php...o&userid=29443
View this thread:
http://www.excelforum.com/showthread...hreadid=491527