Logically, what differentiates a Champion from Oriented from Performance?
Those seem to be the only 3 classifications. You could create an aggregate
score based on the two performance scores and then use this to VLOOKUP a
classficiation
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Michael" wrote:

I currently have a long If statement to calculate a person's performance
based on their scores. I believe the if statement is too long because Excel
is not liking the formula after I added two more parts to it. If someone has
any idea on how to make this work, I would be more than grateful.


=IF(AND(C3=114,D3=92),"Champion",if(and(c3=114, d3=75),"Oriented",if(and(c3107,
d3-77),"Oriented",if(and(c3=100,d3=79),"Oriented",I f(and(c3=86,d3=80),"Oriented",if(and(c3=85,d3=8 6),"Oriented",if(and(c3=84,d3=87),"Oriented",if(a nd(c3=82,d3=89),
"Oriented",if(and(c3=80,d3=91),"Oriented","Perfo rmance")))))))))

Columns C and D basically just have diffent scores for their performances.

Thanks