+ Reply to Thread
Results 1 to 8 of 8

using or function

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    263

    using or function

    Hi All

    y doesnot below code work when i am trying to check if value entered is either of the two. "run time error mismatch 13".


    Please Login or Register  to view this content.
    Never confuse a single defeat to the final defeat.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,627

    Re: using or function

    Define it as:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    263

    Re: using or function

    can we write a case statement for this . since i have many values like ab / bc and so on

  4. #4
    Registered User
    Join Date
    05-02-2015
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    47

    Re: using or function

    do you mean nested Ifs? like you have corresponding outputs for different entries?

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,627

    Re: using or function

    Of course:

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    263

    Re: using or function

    @zoe what i meant was lets suppose i have either of some 20 choice if the user enters. it should give a particular message.

    instead of writing for each choice what user enters, is there a way where i can write a code if PC is either of the values using if / case

  7. #7
    Registered User
    Join Date
    05-02-2015
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    47

    Re: using or function

    damn, zbor u da man

    @grkchakri zbor did it even before i could say "sabotage"

  8. #8
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    263

    Re: using or function

    Thank u guys for u r help. I could solve my problem with the below code


    Please Login or Register  to view this content.

+ 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: 13
    Last Post: 04-08-2014, 05:46 AM
  2. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  3. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  4. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  5. Replies: 1
    Last Post: 03-21-2012, 11:22 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