View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Long If Statement

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