Help with forumula to change text cell

  • Thread starter Thread starter BerkshireGuy
  • Start date Start date
B

BerkshireGuy

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")
 
Use this where you want it to be.

=IF(Q:Q="CA","California",IF(OR(Q:Q="WA",Q:Q="OR"),"Pacific","Other"))
 
You must log in or register to reply here.

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

Numbers are text and won't match using a formula 1
Retreive part of the value from each cell - Macro and/or forumula 3
to workout the forumula from any column. 1
Reference Global vars in cell formulas? 3
Trying to figure out IF formula 4
Search string with multiple criteria 2
to change the macros as per active cell and range 2
VBA help 5

Back
Top