+ Reply to Thread
Results 1 to 3 of 3

OR Function for Non-Numeric Values

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013
    Posts
    3

    OR Function for Non-Numeric Values

    Hi,

    I am trying to include an OR function within an IF function that reads non-numeric values from a cell, and produces a value_if_true/false depending on the non-numeric values from a specific cell are. Not the best explanation... I know, but here's an example:

    if(A2="apple" OR "oranges",1,2)

    If the word "apple" or "orange" is found in cell A2, return the value=1.
    If a word different from "apple" or "orange" is found in cell A2, return the value=2.

    Thanks

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: OR Function for Non-Numeric Values

    Try something like this:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: OR Function for Non-Numeric Values

    Try

    =OR(A2="apple",A2="orange")

    A shortcut you can use for multiple or values of the same cell

    =OR(A2={"apple","orange","banana","pear","strawberry"})

+ 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] IF function for OK and NC status based on numeric cell values
    By fhadzafar in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-22-2014, 02:54 PM
  2. [SOLVED] Using the lookup function in a column that has alpha-numeric values i.e. a1, b2, c3, etc.
    By ChristianLevi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2013, 07:19 AM
  3. Replies: 9
    Last Post: 11-18-2013, 07:40 AM
  4. [SOLVED] vba macros to force user to input numeric values for numeric values with hyphen
    By Abdur_rahman in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-28-2013, 01:05 PM
  5. [SOLVED] UDF to Vlookup multiple delimited values (numeric/non-numeric) and sum found values
    By Geert Rottiers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 09:30 AM
  6. [SOLVED] Applying IF function for non-numeric values
    By wael_afifi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2013, 04:09 PM
  7. Replies: 1
    Last Post: 06-17-2013, 02:22 PM

Tags for this Thread

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