+ Reply to Thread
Results 1 to 2 of 2

IF statement for multiple words

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    IF statement for multiple words

    Hi there,

    I'd like a formula where if cell $D$45 equals either "Domestic" or "International", the result returns blank, if the cell does not equal "Domestic" or "International", I want the cell to return ", ".

    I usually know how to write IF statements, but this one is confusing me. It's working, but it keeps returning FALSE, even though I have "" in the formula.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: IF statement for multiple words

    Something like...

    =IF(OR(D45={"Domestic","International"}),"",",")
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use a drop down box with IF statement that incorporates multiple words
    By clogistics in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2016, 08:28 PM
  2. IF Statement containing words instead of numbers .
    By 1976dan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2013, 09:32 PM
  3. [SOLVED] Multiple Calculation IF Statement resulting in words HELP!
    By CNNNN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2012, 10:53 AM
  4. if statement distinguishing between words and numbers
    By kamelkid2 in forum Excel General
    Replies: 2
    Last Post: 07-07-2011, 08:20 AM
  5. If statement to return multiple words
    By billykiller05 in forum Excel General
    Replies: 4
    Last Post: 10-14-2010, 04:42 AM
  6. If statement with words
    By golfer2b in forum Excel General
    Replies: 5
    Last Post: 02-12-2010, 09:18 AM
  7. IF Statement equalling multiple words. Please Help
    By Phillip Vong in forum Excel General
    Replies: 4
    Last Post: 03-17-2005, 09:06 PM

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