# Thread: IF - AND - OR (2003)

1. ## 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. ## 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. ## 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. ## Re: IF - AND - OR (2003)

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

5. ## 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
•