Multiple IF values

  • Thread starter Thread starter Murph
  • Start date Start date
M

Murph

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?
 
Hi

It was close...

=IF(K2="Toledo",1,IF(K2="Columbus",2,IF(K2="Cleveland",3,0)))

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Input for Goal Seek 2
If and a date 3
Subtotal and IF Formula 1
Formula assistance column match sum 3
delete row on based on cell value 1
sumifs function 3
Need Formula to "Adjust" to New Column Assignment 3
Bold a cell based upon data in another cell 5

Back
Top