+ Reply to Thread
Results 1 to 3 of 3

if a and (b or c) , if a or (b and c) , if (a and b) or (c and d)

  1. #1
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    328

    if a and (b or c) , if a or (b and c) , if (a and b) or (c and d)

    I know this has to have been asked loads but the keywords are too short to search on.

    How do I control the order of and/or in an if statement?
    Last edited by Leon V (AW); 11-09-2020 at 01:56 PM.
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,408

    Re: if a and (b or c) , if a or (b and c) , if (a and b) or (c and d)

    Unless I am missing something in your question, your thread title seems to suggest you already know how to do it... you use parentheses to group them as appropriate.

  3. #3
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    328

    Re: if a and (b or c) , if a or (b and c) , if (a and b) or (c and d)

    I didn't know but I hoped

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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