+ Reply to Thread
Results 1 to 5 of 5

Using OR to check is a value is true

  1. #1
    Registered User
    Join Date
    07-19-2006
    Location
    Jamaica
    Posts
    86

    Using OR to check is a value is true

    I wanted to make a function that should say IF A1 is equal to 1 or 2 or 3 then TRUE else FALSE. I thought I could do that through

    =IF(A1=OR(1;2;3);TRUE;FALSE) but that didn't work. Now, I understand that it should have said

    =IF(OR(A1=1;A1=2;A1=3);TRUE;FALSE), but I would have preferred a simpler approach. Is there a way to do something like in the first approach?

    /Møller
    --
    M?ller

  2. #2
    Registered User
    Join Date
    03-26-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2019
    Posts
    8

    Re: Using OR to check is a value is true

    =IF(MATCH(A1;!!!Insert list or range here"";0);TRUE;FALSE)

    is one of your options
    --
    TG|ЕS

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,068

    Re: Using OR to check is a value is true

    How about
    =OR(A1={1,2,3})

  4. #4
    Registered User
    Join Date
    07-19-2006
    Location
    Jamaica
    Posts
    86

    Re: Using OR to check is a value is true

    Neat. Thanks.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,068

    Re: Using OR to check is a value is true

    You're welcome & thanks for the feedback.

+ 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. Replies: 5
    Last Post: 03-14-2020, 03:58 AM
  2. If check box value true then yes else no
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2018, 12:55 PM
  3. [SOLVED] I am trying to check if two values are true
    By mikejs20 in forum Excel General
    Replies: 3
    Last Post: 10-22-2014, 05:44 PM
  4. check box when its true
    By sarmoodi in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 06-30-2011, 05:04 AM
  5. Macro to check range, if false check another range until true, then copy
    By jayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2009, 04:19 PM
  6. [SOLVED] check box - true/false/na
    By Kelly 1st in forum Excel General
    Replies: 4
    Last Post: 07-13-2006, 07:50 AM
  7. [SOLVED] check for IsEmpty(MyArray) = True
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 03:05 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