Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF - AND - OR (2003)

    Evening all,

    I can never get my head atound these 'IF AND OR' formula's..... Help Please??

    In a third cell, if either of the two previous cells returns a yes, i want the third cell to say yes, if not .... no.

    eg. if a1 = yes OR if b1 = yes, then yes, if not no.

    Thanks

    nath

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF - AND - OR (2003)

    Try this:
    <code>
    =IF(OR(A1="yes",B1="yes"),"yes","no")
    </code>
    It's important tokeep in mind that AND and OR are functions in Excel, not operators such as + and -.
    The function OR(condition1,condition2) is TRUE if condition1 is TRUE or condition2 is TRUE (or both), and FALSE if both condition1 and condition2 are FALSE.
    The function AND(condition1,condition2) is TRUE if both condition1 and condition2 are TRUE, and FALSE if condition1 is FALSE or condition2 is FALSE (or both).

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF - AND - OR (2003)

    Sorry, I need a third option >>>

    If A1 = nothing,do nothing,if b1 OR c1 = yes, then yes, if not no.

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF - AND - OR (2003)

    Does this do what you want?
    <code>
    =IF(A1="","",IF(OR(B1="yes",C1="yes"),"yes","no")) </code>

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF - AND - OR (2003)

    Perfect Hans, and thanks for the lesson. I need to imbed that into the back of my brain (somewhere).....

    Cheers

    Nath

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •