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")

Help with forumula to change text cell
 

Use this where you want it to be.

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


BerkshireGuy Wrote:
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"

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=52941