Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Michael wrote...
.... =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", If(and(c3=86,d3=80),"Oriented", if(and(c3=85,d3=86),"Oriented", if(and(c3=84,d3=87),"Oriented", if(and(c3=82,d3=89),"Oriented", if(and(c3=80,d3=91),"Oriented", "Performance"))))))))) .... So if I'm reading this right, if both col C = 114 and col D = 92, the result should be Champion, but there's a trade-off between cols C and D to determine whether an individual is Oriented or Performance. That could be handled using nested lookups, e.g., =IF(AND(C3=114,D3=92),"Champion", IF(D3=LOOKUP(C3,{80;82;84;85;86;100;107;114}, {91;89;87;86;80;79;77;75}),"Oriented","Performance ")) Safer and more flexible to put these ranges into a 2-column table. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
IF statement too long, need another way | Excel Worksheet Functions | |||
very long statement | Excel Discussion (Misc queries) | |||
IF statement too long | Excel Discussion (Misc queries) | |||
Long IF Statement | Excel Discussion (Misc queries) |