need help with equation

  • Thread starter Thread starter Jambruins
  • Start date Start date
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
 
Hi
try the following in B1
=IF(OR(A1="Colorado",A1="Detroit"),"W",IF(OR(A1="Boston",A1="Carolina")
,"E",""))

HTH
Frank
 
Back
Top