Combining two separate functions into one function

[Capa]

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!