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?

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?

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?