View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BerkshireGuy[_2_] BerkshireGuy[_2_] is offline
external usenet poster
 
Posts: 21
Default Help with forumula to change text cell

I have a column Q - that has state abbreviations. Trying to have a
forumula that changes those to a region. Can't get this to work. Does
the IF function not support OR? If I dont use the or, works fine.

=IF(Q:Q="CA","California",IF((Q:Q="WA" Or "OR"),"Pacific","Other")