Home 
Search 
Today's Posts 
#1




Nested If/Then statements
Hello Everyone, I sure could use a little help. I started with this If/Then statement and it seems to get hung at what I understand to be the 1st "test". I'm not sure what I'm doing wrong here......I'm loading this statement for 8 different values (all under 500) and its supposed to bring back a response for each value, but all it lists is the V. Any help would be appreciated. =IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF(B 4<=200,"Y",IF(B4<=100,"Z","")))))  qwik6  qwik6's Profile: http://www.excelforum.com/member.php...o&userid=29502 View this thread: http://www.excelforum.com/showthread...hreadid=492068 
#2




Nested If/Then statements
it will return V for any value in b4 <= 500  you need to invert it to get what you want =IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF(B 4<=200,"Y",IF(B4<=100,"Z",""))))) =IF(B4<=100,"Z",IF(B4<=200,"Y",IF(B4<=300,"X",IF(B 4<=400,"W",IF(B4<=500,"V",""))))) will return for B$ Z <=100 Y 100<B4<=200 X 200<B4<=300 W 300<B4<=400 V 400<B4<=500 "" anything else  duane  duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=492068 
#3




Nested If/Then statements
qwik
You kinda got it backwards. If all values are <500 then you will always get "V" Start with the lowest value. =IF(B4<=100,"Z",IF(B4<=200,"Y",IF(B4<=300,"X",IF(B 4<=400,"W",IF(B4<=500,"V"))))) Gord Dibben Excel MVP On Thu, 8 Dec 2005 20:27:08 0600, qwik6 wrote: Hello Everyone, I sure could use a little help. I started with this If/Then statement and it seems to get hung at what I understand to be the 1st "test". I'm not sure what I'm doing wrong here......I'm loading this statement for 8 different values (all under 500) and its supposed to bring back a response for each value, but all it lists is the V. Any help would be appreciated. =IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF( B4<=200,"Y",IF(B4<=100,"Z",""))))) 
#4




Nested If/Then statements
Thanks everyone, I really appreciate the help. Your info helped get me over that hurdle. It sometimes sucks when you're trying to teach yourself without anyone to work with.  qwik6  qwik6's Profile: http://www.excelforum.com/member.php...o&userid=29502 View this thread: http://www.excelforum.com/showthread...hreadid=492068 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How to add more than 7 if nested statements. 7 is the limit.  Excel Discussion (Misc queries)  
Nested IF statements  Excel Worksheet Functions  
Employing constant arrays to limit nested IF statements.  Excel Worksheet Functions  
Nested If/Then Math Expert Needed  Excel Worksheet Functions  
If/Then statements with images???  Excel Worksheet Functions 