| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| 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 | |||
Threaded Mode
