need help with equation

J

Jambruins

I am not sure if this can be done in excel. For example, I want cel
B1 to have a W if cell A1 is Colorado or Detriot but an E if cell A1 i
Boston or Carolina. Is there a way to do this? Thank you.

I tried entering if (A1=Colorado, "W", "E") but excel doesn't recogniz
Colorado so it gives me an error
 
F

Frank Kabel

Hi
try the following in B1
=IF(OR(A1="Colorado",A1="Detroit"),"W",IF(OR(A1="Boston",A1="Carolina")
,"E",""))

HTH
Frank
 

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

making cells uncopyable 1
Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
If, Or, and 5
Merging cells and formats 8
2 Formulas needed!!! :) 13
How do I install Microsoft Equation 3.0 back to Office 365? 0
At each change in data concatenate text values in contiguous ranges 2

Top