LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default Long If Statement

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't add 7th IF statement to long formula. manxman Excel Worksheet Functions 7 June 8th 06 08:23 AM
IF statement too long, need another way Lady_Olara Excel Worksheet Functions 4 April 12th 06 10:28 AM
very long statement Frank Drost Excel Discussion (Misc queries) 0 January 18th 06 08:47 PM
IF statement too long KSH Excel Discussion (Misc queries) 6 November 3rd 05 07:28 PM
Long IF Statement rmitchell87 Excel Discussion (Misc queries) 2 October 2nd 05 03:50 AM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"