Combining two separate functions into one function

**Capa** · 02-16-2010, 02:38 PM

Hello, this is my first time posting. I had posted this question in the general forum, and I would erase from there it if I could since I know I'm not supposed to double post.

The question seemed more relevant in this "new users" forum because I'm totally new to Excel and trying to figure things out. So perhaps a moderator can erase the original post.

I'm trying to create a function for cell B2 that would have the following components:

If cell B3 is the letter "A" and cell B4 < 0, then output the word "YES"; otherwise output the word "NO." I have managed to make this component work by itself:

=IF(AND(B3="A",(B4<0)),"YES","NO")

Also, if B3 is the letter "Z" and B4 < 0, then output the word "NO"; otherwise output the word "YES." That string works by itself:

=IF(AND(B3="Z",(B4<0)),"NO","YES")

What I am having a ridiculously hard time figuring out is how to include both strings in the same formula. I'm sure it's not too hard, but I just can't seem to do it. I think it must involve the "OR" command somehow...? Thanks for any help!

**sailepaty** · 02-16-2010, 02:46 PM

Try this

=IF(AND(OR(B3="A",B3="Z"),B4<0),"NO","YES")

Regards

**JBeaucaire** · 02-16-2010, 02:52 PM

I would think it would be:

=IF(OR(AND(B3="Z",B4<0), AND(B3="A",B4>=0)), "NO", "YES")

**Capa** · 02-16-2010, 02:58 PM

Originally Posted by sailepaty

Try this

=IF(AND(OR(B3="A",B3="Z"),B4<0),"NO","YES")

Regards

Thank you, but the problem is that I want it to say "NO" if B4<0 *only* when B3="A". In the second condition of the OR, B3=Z, it's the reverse. In that case I would want it to say "YES" if B4<0 and "NO" otherwise.

The way it's written above, it will output the same word regardless of whether B3="A" or "Z", but I want it to output the opposite word for each case.

Thanks again!

**Capa** · 02-16-2010, 03:08 PM

Originally Posted by JBeaucaire

I would think it would be:

=IF(OR(AND(B3="Z",B4<0), AND(B3="A",B4>=0)), "NO", "YES")

Worked perfectly! Thanks for the help, awesome site

**sailepaty** · 02-16-2010, 03:10 PM

Mine was a wrong answear.

**Richard Buttrey** · 02-16-2010, 03:18 PM

Hi,

Try

Please Login or Register  to view this content.

**JBeaucaire** · 02-16-2010, 03:22 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

============
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

**Capa** · 02-19-2010, 02:47 PM

Originally Posted by JBeaucaire

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

============
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

Ok, I did both. just saw your post now.