Not clear what difficulty you are experiencing. Do you have two criteria,
call score and rollovers, and that you want to calculate each bonus and add
them. And what does that bump-up statement mean? Perhaps an example would
help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jiffy97" wrote in
message ...

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