+ Reply to Thread
Results 1 to 4 of 4

Does the OR function only return True or False?

  1. #1
    Forum Contributor
    Join Date
    03-14-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    102

    Does the OR function only return True or False?

    Or can I use it in an IF statement to select multiple pieces of data to check against?

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Does the OR function only return True or False?

    Hi -

    Yes, OR returns a 1 (TRUE) if any of the tested conditions are true or returns a 0 (FALSE) if all of the tested conditions are false.

    The OR function is very often nested within IF statements.

    Hope this helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Does the OR function only return True or False?

    I suppose OR can return an error as well.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Does the OR function only return True or False?


+ 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. [SOLVED] FIND Function: Possible to return True or False?
    By McStagger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-29-2017, 10:21 AM
  2. How to get an AND function to return back results other than "True and False"
    By bunnyfrostr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2014, 05:10 PM
  3. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  4. Function to search Column for a range of values and return TRUE or FALSE
    By BamBamMoneyBags in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-05-2013, 05:59 AM
  5. Excel Macro : Function that will return true or false if a value exist in a column
    By student1976 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2011, 09:39 AM
  6. [SOLVED] Search for 2 true arguments and return true or false
    By David in forum Excel General
    Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  7. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM

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