+ Reply to Thread
Results 1 to 3 of 3

=IF(OR Function

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    =IF(OR Function

    Hello everyone, I am the new kid on the block. Need help with the above function.

    Cell A1 = TX

    Cell A2 = =If(OR(A1,= NM,AL,FL),"Yes","No")

    I would expect "No" to be in Cell A1

    I get error message #NAME?


    What's wrong with the formula
    Last edited by jerval451234; 01-09-2013 at 11:50 PM.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: =IF(OR Function

    Here is my cheat sheet on using IF(OR... with multiple options.

    HTML Code: 
    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Solved

    Just for clarification, the curly brackets are not put in by the user, but by Excel for array formulas. Array formulas are entered using Ctrl + Shift + Enter not just Enter. If you do this correctly then the curly brackets will be added by Excel.

    Hope this helps.

    abousetta
    Last edited by abousetta; 01-10-2013 at 09:20 AM.

+ 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