| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I relate more than 7 cells with IF(...
I have to relate a list of Names to a special code, no problem with up to 7
by using the nest function. example : A B C D 10 USA ABC Co. 93246 20 Canada DEF Firm 38490 30 Brasil XXY Ltd. 12345 40 Germany ... ... ... 50 Egypt ... .... For the moment I work with =IF(B2="USA";10;IF(B3="Canada";20;IF(B4="Brasil ... my list of names is longer than 7, which does not work, or ? Intention is to fill automatically a column ( in this case A ) referred to a column you just typed in (e.g. B ). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
