+ Reply to Thread
Results 1 to 2 of 2

Help with forumula to change text cell

  1. #1
    BerkshireGuy
    Guest

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


  2. #2
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120
    Use this where you want it to be.

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


    Quote Originally Posted by 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")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1