+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : using AND as well as OR in an IF statement

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    using AND as well as OR in an IF statement

    I am trying to evaluate data in 2 fields and post a text response to the evaluation of the 2 fields. here is what my formula looks like:

    =IF(AND(OR(C82=55,56,57,58,59,60,61,62,63,64), C83>100000), "TRUST RANGE", "NOT TRUST RANGE")

    Now I am not getting an error message but the formula is not evaluating the data in C82 correctly with C83.
    If I enter 61 in C82 and 100500 in C83 I am getting the correct response of "TRUST RANGE" But if I change the 61 to 66 the response does not change to "NOT IN TRUST RANGE" as it should.

    I have tried googling for any information if I can use both an AND & OR in a IF but I can not find anything on it.

    Anyone out there have any suggestions on how I can do this?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: using AND as well as OR in an IF statement

    Try like this

    =IF(AND(OR(C82={55,56,57,58,59,60,61,62,63,64}), C83>100000), "TRUST RANGE", "NOT TRUST RANGE")
    Audere est facere

  3. #3
    Registered User
    Join Date
    07-29-2011
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: using AND as well as OR in an IF statement

    thank you, a thousand times thank you!!!!!!!!!

+ 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