+ Reply to Thread
Results 1 to 4 of 4

IF Statement with an OR

  1. #1
    Registered User
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    2010
    Posts
    59

    IF Statement with an OR

    I'm trying to write an IF statement with an OR, so that if what's in C2-7 starts with a 5 or a 2 it brings back a "Correct". If it doesn't start with either of those, then I want it to be blank.

    I wrote the below and I can't figure out why it's not working.

    =IF(OR(RIGHT(A3,1)="2",RIGHT(A3,1)="5"),"Correct","")

    I've attached the worksheet - I feel like I'm missing something obvious.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,287

    Re: IF Statement with an OR

    Change both instances of RIGHT to LEFT!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    2010
    Posts
    59

    Re: IF Statement with an OR

    I'm even having difficulties replying.

    In any event, thank you - totally correct! It's been a long day.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,287

    Re: IF Statement with an OR

    You're welcome!

    In future, please use thread titles that describe your problem clearly.

+ 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