+ Reply to Thread
Results 1 to 4 of 4

IF OR AND, multiple criterias formula construction?

  1. #1
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    IF OR AND, multiple criterias formula construction?

    Hi all

    I can't get a formula to work today can someone help please?

    I have fruits and packaging options, and there are some new packaging options which are not available for all the fruits yet.

    Raspberries and Strawberries can't be in baskets and crates yet, so I have a column in which I would like to write a formula, that spells "Mistake" if for Raspberries or Strawberries the listed packaging option is basket or crate, returns nothing if the packaging option is anything else.

    Something like:

    =IF(AND(OR(A2<>"Basket",A2<>"Crate"),OR(B2="Raspberry",B2="Strawberry")),"Mistake","")

    But this formula returns "Mistake" even if the packaging option is something else not Basket or Crate.. Not sure what I did wrong.

    It has to return "Mistake" only if:

    Raspberry - Basket
    Raspberry - Crate
    Strawberry - Basket
    Strawberry - Crate

    are in A and B columns.

    If its anything else:

    Raspberry - Box
    Mango - Crate

    It should return nothing ("")

    Please help!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: IF OR AND, multiple criterias formula construction?

    IF(AND(OR(A2="Basket",A2="Crate"),OR(B2="Raspberry",B2="Strawberry")),"Mistake","")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    08-29-2017
    Location
    London England
    MS-Off Ver
    2016
    Posts
    194

    Re: IF OR AND, multiple criterias formula construction?

    Oh couldn't see the forest by the trees.. Thanks!

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: IF OR AND, multiple criterias formula construction?

    You're welcome.

    It's actually funny when someone describes what they want specifically in words and you look at the description and say to yourself
    "But they've clearly defined what they want, they know how to use IF AND OR, how can not just translate that description?" :-)

    No worries, at least you have the solution!

+ 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: 6
    Last Post: 02-23-2018, 07:09 PM
  2. [SOLVED] Which formula to use with multiple criterias?
    By sbea114 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2017, 12:43 AM
  3. Formula to get an value from multiple criterias
    By Vikramchetan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-19-2017, 10:46 AM
  4. IF formula or multiple criterias
    By Doongchen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2016, 10:32 PM
  5. multiple criterias in SUMIF formula
    By aysrun in forum Excel General
    Replies: 8
    Last Post: 07-29-2009, 02:40 AM
  6. making a formula with multiple criterias
    By abrunstad in forum Excel General
    Replies: 4
    Last Post: 03-30-2009, 05:23 PM
  7. Creation formula with multiple criterias
    By s-vadik in forum Excel General
    Replies: 13
    Last Post: 10-24-2008, 02:35 AM

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