| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF values
Trying to assign values to certain text in a column
K2 =City I want L2 to show a number reference for that city. If K2 = Columbus then L2 = 1 If K2 = Denver then L2 = 2 I went to this.. and it failed =IF(K2="Toledo",1,0):IF(K2="Columbus",2,0): IF(K2="Cleveland",3,0) Help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF values
Look in the help index for VLOOKUP or just LOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "Murph" wrote in message ... Trying to assign values to certain text in a column K2 =City I want L2 to show a number reference for that city. If K2 = Columbus then L2 = 1 If K2 = Denver then L2 = 2 I went to this.. and it failed =IF(K2="Toledo",1,0):IF(K2="Columbus",2,0): IF(K2="Cleveland",3,0) Help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF values
Hi
It was close... =IF(K2="Toledo",1,IF(K2="Columbus",2,IF(K2="Clevel and",3,0))) Regards, Per "Murph" skrev i meddelelsen ... Trying to assign values to certain text in a column K2 =City I want L2 to show a number reference for that city. If K2 = Columbus then L2 = 1 If K2 = Denver then L2 = 2 I went to this.. and it failed =IF(K2="Toledo",1,0):IF(K2="Columbus",2,0): IF(K2="Cleveland",3,0) Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| How to calculate values in multiple values with multi conditions | Excel Worksheet Functions | |||
Linear Mode
